Subtracting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Skip - 09 Dec 2006 12:57 GMT

Have two rows of statistics. Would like to subract the smaller cell
from the larger cell, AND have the difference show up in the column
with the largest number. Example

50 ( would like this cell to remain empty)
75 (would like the 25 to appear in this cell, and in the same row
as the 75)

Any help would be appreciated.
Skip

Reply to this Message

Bob Phillips - 09 Dec 2006 13:20 GMT

You cannot overwrite a cell value without code as the cell cannot hold both
a formula and a value.

You could put this in a separate cell

=ABS(A2-B2)

Signature

---
HTH

Bob

(change the xxxx to gmail if mailing direct)

> Have two rows of statistics. Would like to subract the smaller cell
> from the larger cell, AND have the difference show up in the column
[quoted text clipped - 6 lines]
> Any help would be appreciated.
> Skip

Reply to this Message

Ron Rosenfeld - 09 Dec 2006 13:21 GMT

>Have two rows of statistics. Would like to subract the smaller cell
>from the larger cell, AND have the difference show up in the column
[quoted text clipped - 6 lines]
>Any help would be appreciated.
>Skip

Assume:

A1:    50
B1:    75

Do you want to have:

A1:    50
B1:    25

??

If so, for the purposes of verification, how will you tell that you have
already processed this once? Do you want to change the font? color? interior
color?

What if you want to process it a second time?

I suppose you could keep a list someplace of processed cells, but you'll have
to specify.

To compute is simple. The formula is:

=ABS(A1-B1)

And you could write a macro to save the higher value someplace on the
worksheet, and only process if that "someplace" is blank.

Is that something you want?

--ron

Reply to this Message

Rate this thread: