Error is #VALUE!

[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

 

[boblarson]

I think you should post this to an Excel Newsgroup. This is for Microsoft
Access, the database program.

But, since I think I know the answer -

Instead of "=I4-Q4" for Column B, you should use

=IF(Q4<>"",I4-Q4,I4)

--
Bob Larson
Access World Forums Administrator

Tutorials at http://www.btabdevelopment.com

__________________________________

 

[isikawa]

sayounaraï¼ï¼