Excel Formula
Budget: $10 – $30 USD
I need an excel formula to calculate prices that are in a specific column similar to the below.
Example:
If prices in the column are like the below then they need to be adjusted accordingly in the next column
£0.00 - £1.00 - increase by 60%
£1.01 - £1.50 - increase by 50%
£1.51 - £2.00 - increase by 40%
£2.01 - £3.00 - increase by 35%
£3.01 - £99.99 - increase by 33%
£100 and above - increase by 30%
Example:
If prices in the column are like the below then they need to be adjusted accordingly in the next column
£0.00 - £1.00 - increase by 60%
£1.01 - £1.50 - increase by 50%
£1.51 - £2.00 - increase by 40%
£2.01 - £3.00 - increase by 35%
£3.01 - £99.99 - increase by 33%
£100 and above - increase by 30%