View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK
 
Posts: n/a
Default Help with functions

Try this:

=IF(F35=0,0,IF(F35<=50,20,MAX(30,F35*0.15)))

Hope this helps.

Pete