How to write a formula for a price that is multiples for one amoun

L

louisvilleavonlady

I sell Avon and alot of times I run across a product that you can sell 3 for
$5.00. I use excel to create customers invoices and I was wondering if there
is a way that I could write this formula and have it come out correctly. I
know that two of the prices would be $1.67 and the third would be $1.66. So
how could I write this by using a formula?
 
B

Bob Phillips

Why not have all at a price of 1.6666667

and calculate the amount as

=ROUND(num*price,2)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
J

JLatham

Bob Phillips has given a good answer, another option would be
= num * Round((price/grp_num),2)
where num is the actual number purchased and grp_num is the discount
quantity number. Price is the discounted quantity purchase price.

or wrap it up differently
=Round(num * (price/grp_num),2)
 
Top