Error is #VALUE!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Shakeel - 31 May 2008 05:29 GMT

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

Reply to this Message

boblarson - 31 May 2008 06:48 GMT

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)

Signature

Bob Larson
Access World Forums Administrator

Tutorials at http://www.btabdevelopment.com

__________________________________

> Hello all
> My problem is I have simple formula in column B, "=I4-Q4", but I got #VALUE!
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message

isikawa - 31 May 2008 10:08 GMT

sayounara！！

Reply to this Message