View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default Problems entering a formula

=IF(G39="","",IF(G39300,G39*15%,45))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Amste" wrote in message
...
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(G39300,G39*15%,IF(G39<300,"45.00",IF(G39=0,"" ))), but it does not

seem
to work.
Thanks in advance!