Thread
:
Nested IF statements
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett