Problems entering a formula

[Guest]

Hi everyone,
Was just wondering whether someone could help me enter a formula that will
indicate if cell G39 is greater than 300 to multiply the amount in G39 by
15%, if it is less than 300, to return the value of $45.00 and if the cell is
empty to return a blank cell. I have tried the following
=IF(G39>300,G39*15%,IF(G39<300,"45.00",IF(G39=0,""))), but it does not seem
to work.
Thanks in advance!

 

[Bob Phillips]

=IF(G39="","",IF(G39>300,G39*15%,45))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Ian]

Working through your original formula.
If G39>300 then 15% is calculated (1st condition satisfied)
If G39<300 then "45.00" (2nd condition satisfied). The 45.00 will be entered
as text, so cannot be used in calculations.
The 3rd condition (G39=0) will never be tested because 0 < 300
Try this:

=IF(G39=0,"",IF(G39>300,G39*15%,45))

If G39=0 then blank cell
If G39>300 then 15%
Anything else = 45

 

[Guest]

Thanks for the breakdown of the problem, helps to understand better and for
the new along w/explanation. Ihave tried it and it works.