Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problems entering a formula
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problems entering a formula
Working through your original formula.
If G39300 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(G39300,G39*15%,45)) If G39=0 then blank cell If G39300 then 15% Anything else = 45 -- Ian -- "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! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problems entering a formula
Thanks for the breakdown of the problem, helps to understand better and for
the new along w/explanation. Ihave tried it and it works. "Ian" wrote: Working through your original formula. If G39300 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(G39300,G39*15%,45)) If G39=0 then blank cell If G39300 then 15% Anything else = 45 -- Ian -- "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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 Nesting questions | Excel Worksheet Functions | |||
formula problems | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
problems entering in numbers | Excel Discussion (Misc queries) | |||
entering matrix formula | Excel Worksheet Functions |