You've forgotten the precedence of arithmetic operations. If you want
something other than the standard precedence, you need to include
parentheses to specify the precedence.
=E15+14.86*D15*PI()*F15*0.85 is not the same as
=(E15+14.86)*D15*PI()*F15*0.85

Type the word precedence into Excel help.
--
David Biddulph

jollydottie wrote:
on Excell
=E15+14.86*D15*PI()*F15*0.85 =139.0444
on my calc
=20 + 14.86 = 34.86 x 6 = 209.16 x PI = 14.462 x .500 = 7.23
x .85 = 6.1465- this is the right answer

So what am I doing wrong?

"Gary''s Student" wrote:

In an empty cell, enter:
=PI() and format the cell to display 15 places to see:

3.141592653589790

This is the approximation Excel uses for pi.
--
Gary''s Student - gsnu200825


"jollydottie" wrote:

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.