View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sarah@LaborSource Sarah@LaborSource is offline
external usenet poster
 
Posts: 1
Default How to make "If,then" formulas with THREE outcomes

Hello. I am trying to create a formula to calculate commissions. I need to
make a formula that says:

If sales are below $150K, commission is 1.25%. If sales are $150-$200,
commission is 1.75%. If sales are above $200, commission is 2.5%.

Thanks!
Sarah