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