I Just need to make a SIMPLE sumif.
100 90 cut fill

if the difference between cell 1 and 2 if less then 0, then put it in cell
3, if not leave it blank

if the difference between cell 1 and 2 if greater then 0, then put it in
cell 4, if not leave it blank.

help!
--
live long and prosper

In cell 3
IF((A1-A2)<0,A1-A2,"")

In cell 4
IF((A1-A2)0,A1-A2,"")

"REPorter" wrote:

I Just need to make a SIMPLE sumif.
100 90 cut fill

if the difference between cell 1 and 2 if less then 0, then put it in cell
3, if not leave it blank

if the difference between cell 1 and 2 if greater then 0, then put it in
cell 4, if not leave it blank.

help!
--
live long and prosper

Assuming cell 3 is actually C1, then try this:

=IF(A1-B1<0,A1-B1,"")

and put this in D1:

=IF(A1-B10,A1-B1,"")

If A1 is the same as B1 (so the difference is zero), then both cells
will appear blank.

Hope this helps.

Pete

On Oct 30, 6:53*pm, REPorter
wrote:
I Just need to make a SIMPLE sumif.
100 * *90 * * *cut * * * *fill

if the difference between cell 1 and 2 if less then 0, then put it in cell
3, if not leave it blank

if the difference between cell 1 and 2 if greater then 0, then put it in
cell 4, if not leave it blank.

help!
--
live long and prosper