View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR CLR is offline
external usenet poster
 
Posts: 594
Default 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