Formula Help

M

Mel

I'm trying to figure out how to calculate the number of no
charge merchandise a person should get if a company offers
to buy 8 get 1 free(9th). Could someone please verify if
this is correct?

Purchase = 112
Purchase Quantity = A1*(8/9)= 99.6
Free items = A1*(1/9)=(12.4)

Is this correct?

Melanie
 
M

Myrna Larson

To calculate the number of free items, which must be a whole number, right?

=INT(A1/9)

Then the paid-for items is calculated by

=A1-INT(A1/9)

For 112 items purchased, the results are 12 and 100.
 
Top