Problems entering a formula

A

Amste

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!
 
B

Bob Phillips

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
I

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
 
A

Amste

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top