taffmorgan7274
New Member
- Joined
- Aug 29, 2021
- Messages
- 14
- Office Version
- 365
- Platform
- MacOS
Is there a formula for calculating the sum if the price of an item is £20 but on offer for 3 for £50. I would have the £20 price in cell A1 and I would like to find out a formula which would calculate if somebody purchased multiples of 3 or calculate a multiple of 3 and anything which is non multiple eg if a customer bought 5 items.