#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

How to correct a #N/A in vlookup 1
How to use/create code in MS Word to calculate age? 0
#VALUE! when trying to sum from a VLOOKUP 3
Can't seem to delete all images from a Word Doc 2
Dealing with the error: unable to filter on excel hc home school 0
Transfer data between two tables 3
Calculate the median value before a specified list 0
Mail Merge Switch - Dollars to Words 0

Top