Fact(.4). That's a cleaver idea. :)

Ok. Here's my idea for a repeating 4 then.

=SQRT(4)/SQRT(--("." & REPT(4,44)))

Which equal 3. :)

--
Dana DeLouis
Win XP & Office 2003


"JayBea" wrote in message
...
Thanks for the replies Dana

I did manage to get 99 with a bit of a cheat, by using Fact(.4) in the
formula as Excel produces the answer of 1 which applies for any number
below 2

eg. =FACT(4)*4+SQRT(4)+FACT(0.4)
or=FACT(4)*4+4-FACT(0.4)

OK it is a huge cheat, I Know, but it does get Excel to provide the right
answer :-)

I would love to see an Excel math function for recurring numbers in the
next
edition just to be able to overcome this problem without cheating, but
then
again there isn't even a SQRT button on the MS scientific calculator yet
:-)



However, I am not showing any solutions for 99.
For 98, I count 52. ie




=4*FACT(4) + 4/SQRT(4)
=(4+FACT(4)*4)-SQRT(4)

and for 100, I count 99 solutions.
ie =4*(FACT(4)+FACT(4)/FACT(4))

However, I'm showing nothing that totals 99.