Nested IF statements

T

TwoDot

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
 
D

Don Guillett

Did you look in the help index for IF? Try
=if(a2>2400,a3*.25,(a3-265)*.25)
or
if(a2<=2400,a3-265,a3)*.25
 
M

Martin Fishlock

Hi:

if the value is in cell A1:

=if(A1>2400,A1/4,(A1-265)/4)
or:
=if(A1>2400,A1,A1-265)/4
 
C

CLR

=IF(ISNUMBER(A1),IF(A1<=2400,(A1-265)*0.25,IF(A1>2400,A1*0.25,"")),"Cell
contains TEXT")

Vaya con Dios,
Chuck, CABGx3
 
Top