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
|