| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula for number of goods bought - HELP!!
I want to create the following formula but not sure which syntex to use.
We sell goods, the more you buy the cheaper they get. So if you buy 1-24 peices they cost £142 each, if you buy 25-99 they go down 10% to £128 and so on. I need to create a running total with this information. So Mr X buys 10 pieces in Jan (so he is paying £142) but in Mar he buys 25 (so his price reduces to £128). How can I write this as a formula. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| countif formula to find the occurances of a number that is greater than one number but less than another | Excel Discussion (Misc queries) | |||
| how do I set up time sheet and items bought expense sheet | Excel Discussion (Misc queries) | |||
| counting the number of times something is bought during a month | Excel Worksheet Functions | |||
| Database for Purchased goods | Excel Discussion (Misc queries) | |||
| I need to learn excel, i bought 3 books but i need excel on my co. | New Users to Excel | |||
Threaded Mode
