- Joined
- Dec 14, 2017
- Messages
- 1
- Reaction score
- 0
Looking for one formula to calculate the following for commission: Profit is a cell and formula needed in separate cell needs to do the following: below 250 = 0, between 250 and 500 = 20, between, 500 and 1000 =40, above 1000 = 60). i.e. where the profit cell shows say £600 the cell with the formula would show £40. Can anyone help.