Circular Reference Warning in addition

[Goodmifkt]

40 (a1) 15(b1) 25(c1)

I wanted it this way b1 = a1-c1 and c1 = a1-b1
so whenever I make a change in either b1 or c1, it automatically fixed the other cell and make the total of A1

But when I put the formulas, I get the 'Circular Reference Warning', I click okay but then the functions don't work properly. It only works for either b1 or c1. Is there anyway that I can make both work together.

Ex. 40 15 25 (if I make it 26 from 25, it'll change 15 into 14)
40 14 26 (and again if I make 14, 12, it'll automatically, change 26 into 28)
40 12 28

Thanks in advance!

[MrShorty]

Spreadsheets are designed so that each cell either holds a formula or a value. This kind of "edit and calculate in the same cells" programming doesn't really work using the "spreadsheet" programming language.

If you are willing to move the programming to another programming language (usually VBA when working in Excel), then you can have the VBA (or other programming language) do the processing, and the spreadsheet cells simply become input/output containers. One example using a VBA workbook_sheetchange event procedure: https://www.excelforum.com/excel-pro...-function.html

Personally, I would probably designate a trio of cells for the inputs, then a second trio of cells for the outputs:

Enter 40 into A1, leave B1 blank, 25 in C1.
A2 =IF(ISBLANK(A1),B1+C1,A1)
B2 =IF(ISBLANK(B1),A1-C1,B1)
C2 =IF(ISBLANK(C1),A1-B1,C1)

Now I can enter a value in any 2 of the cells in row 1, Row 2 then outputs the desired results based on which input cell was left blank.