From: Arul on
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
From: Rick Rothstein on
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" <Arul(a)discussions.microsoft.com> wrote in message
news:D32E47C5-5664-42DB-BE50-521BB9F41A63(a)microsoft.com...
> 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