Using IF or IFS to clear range when a fixed cell value changes

[JulianvO]

Greetings

I have an attendance register, which changes the year using a spin button.

Cell A2 contains the minimum value for the spin button, namely 2025. this increased by 1 every time the spin button is activated.

However, changing the year does not clear the range of attendance data.

I know this can be done in VBA, but I would like to do this using a formula.

I have tried =IF($A$2= $A$2+1;D4:AL10="") This does not work.

Any pointers / solutions?

Thanking you in advance

Juian

 

[Fluff]

Firstly A2 can never = A2+1, secondly a formula cannot remove data from other cells (unless the whole range is a single spill range)

 

[JulianvO]

Firstly A2 can never = A2+1, secondly a formula cannot remove data from other cells (unless the whole range is a single spill range)

Greetings Fluff

Thanks for the heads up.

 

[Fluff]

You're welcome & thanks for the feedback.