Forum Discussion

Iron Contributor

Mar 12, 2022

Solved

Dynamic Substract

Hello Everyone, I would like the number in cell C2 to decrease every time I add a number to the whole of the column C. I would like for any number I enter into the B column to be subtracted automat...

Substract.xlsx15 KB

Formulas and Functions

Gaurav675
Mar 12, 2022
Excel

Use this formula =$C$2-SUM($B$3:B3). Also, I have attached screenshot for reference.

Excel

Iron Contributor

Mar 12, 2022

Sir! is it possible to automatic change in C2 when we enter number in B2?

Riny_van_Eekelen

Platinum Contributor

Mar 12, 2022

Excel Not sure what you mean but perhaps like in the picture below??

Excel
Iron Contributor
Mar 12, 2022
It helps.
Thank you so much sir.