How can I create this argument? For every 20 you get 2?

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

How can I set this up in excel?

The rule is, 2 items free per 20 items

example.

For every 20 items you get 2 extra
for 40 you get 4
60 you get 6
I want the calculation to continue for each allotment of 20 in a total
amount and then put that answer in the Items Free column.

Thanks,

Mark
 
How about:

=2*INT((A1)/20)

Where A1 contained the total.

But if you bought 39, this would only give you 2 free.
 
Yes Dave, it worked great, and I have made sure I understand this formula
and not just cut and pasted it in..Thanks for your help.

Mark.
8)
 
Back
Top