two-variable calculations

[fredonic]

If I input a formula e.g. ‘A1+B1=C1’; how do I tell excel to calculate B1 if
I have A1 and C1’s values or A1 if I have the other 2 values – doing all this
using only the 3 original cells

 

[Gary''s Student]

Use a worksheet change event macro. It can detect two cells entered and
calculate the third, See:

http://www.mvps.org/dmcritchie/excel/event.htm#wb_shtChange

 

[fredonic]

Could you be more specific, as I am still learning to program in excel.