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.

Mark wrote:

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

--

Dave Peterson

Was a worksheet formula ok? You posted in .programming.

Mark wrote:

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

--

Dave Peterson

Thank you Dave, this looks like what I need

Mark.
8)

"Dave Peterson" wrote in message
...
How about:

=2*INT((A1)/20)

Where A1 contained the total.

But if you bought 39, this would only give you 2 free.

Mark wrote:

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

--

Dave Peterson

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)
"Dave Peterson" wrote in message
...
Was a worksheet formula ok? You posted in .programming.

Mark wrote:

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

--

Dave Peterson