double equation
i am trying to do the following excel equation
g14=f14*0.057+10 if f14=0 then g14=0
anyone out there that can help me?
Software
i am trying to do the following excel equation
g14=f14*0.057+10 if f14=0 then g14=0
anyone out there that can help me?
by kriksel Accepted solution
by peconet tietokoneet Accepted solution
http://office.microsoft.com/en-us/excel/HP052001271033.aspx
Creating formulas
http://office.microsoft.com/en-us/excel/CH100648411033.aspx
Array Formulas
http://www.cpearson.com/excel/excelF.htm
by thumbsup2 Accepted solution
... and can be easily learned by reading the built in HELP on functions.
In G14, type the following:
=IF(F14<>0,F14*0.057+10,0)
That says IF F14 is not equal to zero then do the math and put the result in G14, else G14 equals zero.
The math part could also use parenthesis around a portion of the formula if needed, even though the multiplication should take place before the addition, because
(F14*0.057)+10
is different than
F14*(0.057+10)
So, your formula COULD also be written like this:
=IF(F14<>0,(F14*0.057)+10,0)
by yousuck1 Accepted solution
=IF(F14=0,G14=0,G14=F14*0.057+10)
dont know if this is what you wanted
This discussion is closed to new replies.
Sort by Trending