Solly
New member
- Joined
- Dec 5, 2020
- Messages
- 4
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Microsoft Excel Worksheet
Hello guys - i'm a bit of a novice when it comes to Excel but would really appreciate some help with pricing up our commodity. When someone buys 750,000 or 1,000,000 or 3,000,000 etc items we charge in a specific way. The first 500,000 are charged at 1%, the second 500,000 are charged at 0.75%, the next million at 0.5%, the next million at 0.25% and so on an so on
What i'd like to be able to do is to just put one number in and it automatically breaks it all down and charges the correct price at the end.
Is that possible at all ?
Much thanks
What i'd like to be able to do is to just put one number in and it automatically breaks it all down and charges the correct price at the end.
Is that possible at all ?
Much thanks
