rayhanmiah
New Member
- Joined
- Apr 23, 2021
- Messages
- 3
- Office Version
- 2016
- Platform
- Windows
I need help with a formula that makes a value increase/decrease as another value increases/decreases.
For example:
The sales price of £19.60 is equivalent to 900 monthly sales. For every 10p increase in the sales price, the monthly sales drop by 20.
I've tried inverse proportion which worked a little bit (£19.60 = 900) but when I increased the price to £19.70, it returned the value 895 instead of the expected value of 880.
For example:
The sales price of £19.60 is equivalent to 900 monthly sales. For every 10p increase in the sales price, the monthly sales drop by 20.
I've tried inverse proportion which worked a little bit (£19.60 = 900) but when I increased the price to £19.70, it returned the value 895 instead of the expected value of 880.