how to make 3 cells as reference to each other

[KALATRASH81]

HI,
I have 3 cells, A1, A2 & A3
A3 fixed =26
A1+A2=26
the problem, i need when A1 will increase A2 will decrease automatic & Vice versa.
e.g. 25+1=26 then 24+2=26..........

[dilipandey]

Hi Kalatrash81,

Welcome to the forum.

Do you want A1 and A2 to have formulas.. if so, then where would you enter 25 and 1 or 24 and 2 ??

Regards,
DILIPandey

<click on below 'star' if this helps>

[Fotis1991]

Hi

Maybe using in A2?

=A3-A1

[KALATRASH81]

Thanks for your KISS comments