View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
cardfan057
 
Posts: n/a
Default I want to calculate 3 different % from the same cell

I am making an invoice that will figure a discount for a certain amount of
sale, all from the same cell, if the subtotal is < 500 then they will get no
discount, if it is 500 they will get a 5%, and if it is 750 they will get
a 10% discount, what formula do i use??
--
cardfan057