Math Formula

[DaveB]

I'm trying to write a math formula but I don't know how
to write it. Could someone help me. I'd like it to say,
if cell E7 is greater than cell E8 then Cell E9 = 0, but
if cell E7 is less than than cell E8 then Cell E9 = E7
minus E8. The label for this row would be Dave owes Terry.
Then on the cell below that which would be Cell E10 the
formula should be reversed to say if cell E7 is less
than cell E8 then Cell E9 = 0, but if cell E7 is greater
than than cell E8 then Cell E9 = E7 minus E8. This cell
would be labeled Terry owes Dave. Please help. How do I
do this?

 

[Frank Kabel]

Hi
try
=MIN(0,E7-E8)

and
=MAX(0,E7-E8)

 

[DaveB]

Thank you very much

-----Original Message-----
Hi
try
=MIN(0,E7-E8)

and
=MAX(0,E7-E8)


--
Regards
Frank Kabel
Frankfurt, Germany


.

 

[Don Guillett]

how about something like this. What if e7=e8??
=if(e7<e8,e7-e8,if(e7>e8,0,""))