Dear Sir,
I want to calculate formula which refers 3 cells out of 4 cells. for eample
a1=5, a2=2, a3=9, a4=16. i can able enter all the 4 cells, if i enter the
values in cells a1,a2 & a3 the result should come in a4, if i enter the
values in cells a2, a3 & a4 the result should come in a1, like all the 4
cells. |Is it possible in excel?

Thanks,
Arul

That is not possible with formulas, but you can do it with VB... however,
you will need to tell us the calculation relationship between those four
cells before we can show you how.

--
Rick (MVP - Excel)



"Arul" wrote in message
...
Dear Sir,
I want to calculate formula which refers 3 cells out of 4 cells. for
eample
a1=5, a2=2, a3=9, a4=16. i can able enter all the 4 cells, if i enter the
values in cells a1,a2 & a3 the result should come in a4, if i enter the
values in cells a2, a3 & a4 the result should come in a1, like all the 4
cells. |Is it possible in excel?

Thanks,
Arul