the sqrt(4)/sqrt(0.4444444)=3
The function Rept might help, although I don't see a solution for this
problem because you want 0.4444444
=--REPT(4,4)
returns the number 4444.
The best I got so far was...
=SQRT(4)/SQRT(4/((4+4+4/4)))
but it has 6 4's.
since 0.444... equals 4/9
But, the above equation does reduce to =SQRT(4+4+4/4) to return 3.
HTH :)
--
Dana DeLouis
Win XP & Office 2003
"JayBea" wrote in message
...
"Faz" wrote:
JayBea, what exactly do you mean by this?
2/.4~ =3
If you mean something like 0.33333333 and so on, you can put 1/3
From what i see, you're saying 2/0.444444... but that would be 4.5, not
3.
Sorry My mistake on the formula I was thinking of the final result I was
intending which was the sqrt(4)/sqrt(0.4444444)=3 and summarised the
formula
a little too much :-)
The question is asked because of notating the problem of The Four Fours in
Excel where the only digit you can use is the number 4 and no more or less
than four times in the formula. This is why I was looking for the notation
for a recurring number, in order to only use the digit "4" once by
denoting
it as recurring.
eg the formula (Fact(4)*4)+(sqrt(4)/sqrt(.4444444))=99 and would be
correct
but for the fact there are more than Four Fours in it.
|