Nested IF statements
 

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

Nested IF statements
 

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

--
Don Guillett
SalesAid Software

"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

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

Nested IF statements
 

Hi:

if the value is in cell A1:

=if(A12400,A1/4,(A1-265)/4)
or:
=if(A12400,A1,A1-265)/4
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"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

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