Question Locked

double equation

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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?

4 replies

by thumbsup2

... 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

=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.