Incorrect Sum output (1 Viewer)

[ScottXe]

I have two columns getting the values from other worksheet. On other column, I have a simple sum function, such as =sum(P3,Q3). When the P3 is 0.01600046 and Q3 is blank, the output is 0.00000. Can someone advise the possible error for this scenario. Thanks!

 

[arnelgp]

=sum(if(isblank(p3),0,p3), if(isblank(q3),0,q3))

 

[ScottXe]

Thanks for your idea! It does not work out my issue. Upon close examination, the looked blank cell is not blank using isblank function. The cause is the looked numeric value is not a numeric value, text value. If I use value function with looked numeric value, the sum output is correct but the blank cell will cause incorrect output again. Is there any appropriate function for this scenario?

 

[arnelgp]

add IsNumeric to your expression.

=sum(if(Or(isblank(p3),Not(IsNumber(p3))),0,p3), if(Or(isblank(q3),Not(IsNumber(q3))),0,q3))

 

[ScottXe]

It now turns out "#NAME?". Very strange!

 

[arnelgp]

i edited it instead of IsNumeric, i change it to IsNumber.