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