View Single Post
  #6   Report Post  
JayBea
 
Posts: n/a
Default

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.