View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jato Jato is offline
external usenet poster
 
Posts: 2
Default multiplying by variables based off original number

trying to figure this out, im in commsionned sales, and we base our commision
off a percentage of our gross, i need a formula that basically does this
400 or less=100
1500 or less *.25
1501-2499*.3
2499<*.35
all in one formula.... is this possible?