View Single Post
  #2   Report Post  
Lee Harris
 
Posts: n/a
Default What is wrong with this formula?


"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!