Hi

if i'm understanding you correctly then the formulas a

in d1
=IF(A1+B1C1,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


"dd" wrote in message
...
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