Forum Discussion
Solved
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...
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 ">".)
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 ">".)
JoeUser2004 Thank You!! Works perfect!!