simple formula
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 |
simple formula
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 |
All times are GMT +1. The time now is 11:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com