LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
If argument DonaMil Excel Worksheet Functions 1 April 14th 10 04:20 PM
How I can create a function with return argument pol Excel Discussion (Misc queries) 2 November 5th 08 04:16 PM
I Need An Argument newdeas Excel Worksheet Functions 4 July 20th 08 05:27 PM
what is an argument? mcockrel Excel Discussion (Misc queries) 7 March 17th 06 03:21 PM
IF THEN argument Julie Holeman Excel Discussion (Misc queries) 3 January 26th 05 04:22 PM


All times are GMT +1. The time now is 09:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"