2 weeks ago
Hi friends,
I'm currently utilizing an inverse formula to determine the sales price based on gross sales and sales volume.
When I adjust the price, the gross sales are appropriately recalculated. This works well.
Similarly, when I modify the gross sales, the price adjusts accordingly. This is also functioning correctly.
However, when I alter the sales volume, it adjusts the price instead of the desired adjustment in gross sales. Is there a method to achieve this without resorting to the "Lock Cell" feature, perhaps through a default setting?
Kind regards,
Ismail
Have you tried the inverseif() formula?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
71 | |
9 | |
8 | |
6 | |
6 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.