Nested IF statements
One way:
= (A1 - 265 * (A1<=2400)) * 0.25
In article ,
TwoDot wrote:
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
|