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
Inverse is triggered according to the priority (order in which its written) and whether one of the variables are unbooked. But if you adjust one of the variables of the primary formula, primary formula will trigger first.
Price=Gross Sales/Sales Volume, If you adjust the volume it will calculate new price as that's what is your main formula . Unless you lock the Price, any adjustment in GS or SV will first affect price (primary formula)
Inverse will trigger if you change price, in this case Gross Sales will calculate and if you change price and GS Volume will get calculated.
Nikhil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.