| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula for number of goods bought - HELP!!
=K1*142*LOOKUP(K1,{0,25,100},{1,0.9,0.75})
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "MO987654" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula for number of goods bought - HELP!!
Put the quantity in A1 and in B1:
=A1*IF(A1<25,142,128) So to buy 24 will cost 3408 so to buy 25 will cost 3200 -- Gary''s Student - gsnu200787 "MO987654" wrote: 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 |
| Reply |
| 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 | |||
Linear Mode
