Error

[Shakeel]

Hello all
My problem is I have simple formula in column B, "=I4-Q4", but I got #VALUE!
error, Column I have value enter by self, but Column Q have Vlookup formula
i.e. "=IF(O4="","",VLOOKUP(O4,Stock,29,FALSE))"
Simple I need result in Column B "I4-Q4" if Q4 is blank then I4 value in
Column B

Thanks

 

[JE McGimpsey]

One way:

SUM() will ignore text:

=-SUM(-I4,Q4)

 

[muddan madhu]

Try this one =IF(ISERROR(Q4),SUM(I4),SUM(I4,Q4))

 

[Dave Peterson]

One more:
=i4-n(q4)
or
=n(i4)-n(q4)

Hello all
My problem is I have simple formula in column B, "=I4-Q4", but I got #VALUE!
error, Column I have value enter by self, but Column Q have Vlookup formula
i.e. "=IF(O4="","",VLOOKUP(O4,Stock,29,FALSE))"
Simple I need result in Column B "I4-Q4" if Q4 is blank then I4 value in
Column B

Thanks