Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
simple formula for some | Excel Discussion (Misc queries) | |||
Simple formula | Excel Worksheet Functions | |||
IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
Simple problem, simple formula, no FUNCTION ! | Excel Worksheet Functions | |||
Help - Simple Formula ! | Excel Discussion (Misc queries) |