I need help

S

scarlettrose

I know what I want to do but I don't know how to do it, so I was hoping
someone could help.
I need a formula that when I subtract one column from another column
and the answer is in the positive range, meaning greater than 0 the
answer to the problem will be listed in a column and if the answer is
negative meaning less than 0 it is listed in another column.

For example
a b c1 d1
5 4 1 0
5 4 0 1

Thank you for the help. Scarlett
 
P

PCakes

Try these formulas:
=IF(A2-B1<0,A2-B2," ") in Your Positive Column
=IF(A2-B2>0,A2-B2," ") in Your Negative Column
then copy and paste them down.
 
S

Sandy Mann

=IF(A2-B1<0,A2-B2," ") in Your Positive Column

I assume that you have typos and you meant:

=IF(A2-B2<0,B2-A2," ") in Your Positive Column
otherwise it will return a negative number which is not what the OP was
displaying in her? example - not that I understand her example because that
seems to have typos as well.



--
Regards

Sandy
[email protected]
Replace@mailinator with @tiscali.co.uk
 
Top