View Single Post
  #4   Report Post  
Dana DeLouis
 
Posts: n/a
Default

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.