two-variable calculations
 

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

two-variable calculations
 

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

http://www.mvps.org/dmcritchie/excel...m#wb_shtChange

--
Gary''s Student


"fredonic" wrote:

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

two-variable calculations
 

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

"Gary''s Student" wrote:

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

http://www.mvps.org/dmcritchie/excel...m#wb_shtChange

--
Gary''s Student


"fredonic" wrote:

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