Need Excel formulas and guide

Copper Contributor

Hello,

 

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.

Thanks.

0 Replies