#VALUE! when trying to calculate from results of a VLOOKUP

S

Supe

I have a spreadsheet that has a ON HAND and COST column where I get the data
using a VLOOKUP. I want to add a column that will multiplly these two column
if the ON HAND column is greater than zero. I used an IF statement that
would mulitpy these two columns if the ON HAND amout is greater than 0. It
works fine if the cell is greater than zero. If it is blank then I get
#VALUE! listed in the cell. Is there a way to have it appear as 0 or blank
if the ON HAND cell is blank?
 
D

Douglas J. Steele

Your mention of VLOOKUP makes me suspect that you've posted this in the
wrong place.

This newsgroup is for questions about Access, the database product that's
part of Office Professional. You'd be best off reposting your question to a
newsgroup related to Excel.
 

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

#VALUE! when trying to sum from a VLOOKUP 1
Excel Need Countifs Formula Help 0
Combining IF Statement and Vlookup 0
vlookup from right to left 2
DCount works for one field but does not work with two fields 12
Finding value using greater than, Vlookup, and nested If 2
Yes or blank, depending if value equals or exceeds value found inVLookup table. 4
Trying to run excel vba code when cell value changes from empty to entered value. 1

Top