Prev: SUMIF returns no value
Next: How to combine Combo Box function with Vlookup function
From: Arul on 4 Apr 2010 15:52
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 4 Apr 2010 16:03
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

 | 
Pages: 1
Prev: SUMIF returns no value
Next: How to combine Combo Box function with Vlookup function