View Single Post
  #10   Report Post  
scott45
 
Posts: n/a
Default 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