May 03 2022
I'm having a problem with come up with the formulas and how to apply it.
What I'm trying to do is I want to set default to get minus when I click on the price list.
For ex, default is 1000 and there are many other prices below such as 100, 150, 200, 250, and etc.
I want 1000 to be minus when I click on the 100, 150, etc. and when I re-click it, minus will be removed.
I'm not talking about =sum() formula. After I apply the formula at the Total price. I want the number to be adjusted by mouse click.
Please advise me if this is possible to do or not and if it's possible, I would love you to guide me.