Nested IF statements
=IF(ISNUMBER(A1),IF(A1<=2400,(A1-265)*0.25,IF(A12400,A1*0.25,"")),"Cell
contains TEXT")
Vaya con Dios,
Chuck, CABGx3
"TwoDot" wrote in message
...
I want to evaluate a cell reference to determine if the amount is <= 2400.
If the amount 2400 then multiply the amount by .25
If the amount <= 2400 then subtract 265 and multiply the difference by .25
|