Error

S

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
 
D

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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error is #VALUE! 2
Leave final cell blank 2
IF formula with certain conditions to achieve a desired value 2
Copy addition formula of non-consecutive horizontal cells 2
Compute Additional Hours Needed Using "if" or "lookup" 1
change cell color depending on two cell values 1
How do I ignore blank cells while averaging the solutions of equat 2
Combining 4 Conditions into 1 Formula! 7

Top