Subtracting

[Skip]

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

 

[Bob Phillips]

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)

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)

 

[Ron Rosenfeld]

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

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