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