View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete
 
Posts: n/a
Default Need help with nested function...please

Try this:

=IF(c2<=40,0,IF(c2<=45,c2,IF(c2<=50,c2*1.5,c2*2)))

Pete_UK