What is wrong with this formula?
Roger
One other thing. I show a value error when there is no info in the cells I
use. Is it possible to hide the value error?
thanks Scott
"Roger Govier" wrote:
Hi
Try
=((F22*71449*0.4)+16147)/C22
It returns 177.8788
Regards
Roger Govier
scott45 wrote:
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
|