View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacky Jacky is offline
external usenet poster
 
Posts: 20
Default Sale commissions calculations needed

Please help Im confused with if, or's and and formula

if sales target is say 1000
if they dont reach 60% no commission payable
if the reach 60% and over to sales target they get 3%
if they get over target they get 5% of everything over target