Forum Discussion
SamGriswold
Oct 13, 2022Copper Contributor
IF= Formula not allowing SUM
In cell G4 I need to input the employees penetration % for a particular bonus 0-74.99% = -$750, 75-99.9% = $0, and 100%+ = $750
Here is the Formula I used in cell L4 where I need the $$ amount:
=IF(G4<75%,"-$750",IF(G4<100%,"$0",IF(G4>100%,"$750")))
It calculates properly as far showing the proper $$, but the amount will not factor into the SUM (5 total cells for various commissions and bonuses) all others are working properly (cell is set to currency not text)
Here is the spreadsheet:
Any assistance would be appreciated!!
Remove currency symbol and double-quotes around values. The formula should be written:
IF(G4<75%,-750,IF(G4<100%,0,IF(G4>=100%,750)))
or better:
IF(G4<75%,-750,IF(G4<100%,0,750))
(The opposite of "<" is ">=", not ">".)
- JoeUser2004Bronze Contributor
Remove currency symbol and double-quotes around values. The formula should be written:
IF(G4<75%,-750,IF(G4<100%,0,IF(G4>=100%,750)))
or better:
IF(G4<75%,-750,IF(G4<100%,0,750))
(The opposite of "<" is ">=", not ">".)
- SamGriswoldCopper Contributor
JoeUser2004 Thank You!! Works perfect!!