simple formula

[Guest]

value of a1 + b1 if > c1 then show in d1, f1 will remain 0.00 however, if
a1+b1 < c1 then show the value in f1

pl help

thanks

 

[JulieD]

Hi

if i'm understanding you correctly then the formulas are:

in d1
=IF(A1+B1>C1,A1+B1,0)

in f1
=IF(A1+B1<C1,A1+B1,0)

not sure what you wanted to do if A1+B1 = C1

Cheers
JulieD