View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default 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