Help with Excel formula

[flevina]

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.

 

[Peter_SSs]

See if this does what you want

22 02 28.xlsm
	A	B
1
2
3
4		24
5		21
6		abc
7		34
8		2/05/2021
9
10
Decrement

Cell Formulas
Range	Formula
B5	B5	=B4-COUNTA(B6:B1000)

 

[flevina]

See if this does what you want

22 02 28.xlsm
	A	B
1
2
3
4		24
5		21
6		abc
7		34
8		2/05/2021
9
10
Decrement

Cell Formulas
Range	Formula
B5	B5	=B4-COUNTA(B6:B1000)

it works like charm.Thank you so much!

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.