Lee

Look at my second post I had two numbers turned around
10.8*71449=71649
71649*.4=308659
308659+16147=324806
324806/1826=177.87

Thanks Scott

"Lee Harris" wrote:


"scott45" wrote in message
...
The following formula shoud give an answer of 178. I think I am placing
the
parenthesis in the wrong position. If you can help it is greatly
appreciated.
The answer I get is 308669

=(((F22*71449)*0.4)+16147/C22)

Cell-F22 number is 1826
71449 is a constant number
0.4 is a constant number
16147 is a constant number
Cell-C22 is 10.8

Thank you Scott

On what basis do you think you should be getting the answer 178?

if F22 is 1826, then F22*71449 is 130,465,874 (over 130 million)

Even if you've got your 2nd bit wrong, dividing by 16147 gives 8080 to the
nearest whole number.

Even if you actually meant

(0.4*(F22*71449))/(C22*16147)

that still gives an answer of 299 and a bit doesn't it?

by the way, your original formula gives 52,187,845 in my spreadsheet!