Hi Floks,
I am writing code for the decrement the B4 cell value by 1 in Cell B5 when i enter the value in next cell.
EX: I have a value of in cell B4= 24, and wanted to write a formula on cell B5 where it will decreased the cell value by 1 every time when i keep entering the values in next each cell.
if i entered in B6, B5 value should be 23
and if i entered something in B7, B5 would be 22 like this.
please help to write a formula for this.
I am writing code for the decrement the B4 cell value by 1 in Cell B5 when i enter the value in next cell.
EX: I have a value of in cell B4= 24, and wanted to write a formula on cell B5 where it will decreased the cell value by 1 every time when i keep entering the values in next each cell.
if i entered in B6, B5 value should be 23
and if i entered something in B7, B5 would be 22 like this.
please help to write a formula for this.