You are correct that ATAN(1) = pi()/4 and that 4*ATAN(1) = pi
But in your previous message you had said Atan(4) = pi()/4 and 4*ATAN(4)
It has obviously been a long year, Bernard. :-)
--
David Biddulph

Bernard Liengme wrote:
No, I think ATAN(1) = pi()/4 so 4*ATAN(1) = pi
Please check on worksheet and let me know if I am wrong - it has
happened before!
Happy New Year

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
ATAN(1), not ATAN(4), I think?
But yes, it'll work to 15 sig figs, not just 10.
--
David Biddulph

Bernard Liengme wrote:
Why only 10 decimal places?
Mathematically Atan(4) = pi()/4,
Then 4*ATAN(4) and PI() must give exactly the same answer within the
precision of Excel (15 decimals)
best wishes

"Rick Rothstein" wrote in
message ...
If you have trouble remembering or finding the constant value, but
have a good memory for simple formulas, this will generate PI to 10
significant figures (usually more than enough for any calculation
involving it)... =4*ATAN(1)

--
Rick (MVP - Excel)


"jollydottie" wrote in
message ...
Using the calculator I get a different answer, if PI = 3.162. then
*3.162 in
Excell should give me the right answer but it doesn't.