View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mark[_20_] Mark[_20_] is offline
external usenet poster
 
Posts: 4
Default How can I create this argument? For every 20 you get 2?

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