Removing #VALUE!

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

OK one more 'last' question...

In column K I total the result of the VLOOKUP * the quantity I enter into
column J, but if there's nothing in J it shows, #VALUE! It's just =I11*J11

How do I make it show nothing in the cell instead of #VALUE!.........?
 
You must log in or register to reply here.

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

Would like cell data to be more editable and work with formula 2
How to set cell value to emptry if three other columns are empty too 1
function help, sumif?? 2
Autofill Dynamic Range 1
Formulas 1
VBA group the number in the Column and Copy to the new worksheet. 0
match formula question with isna 1
Time Sheet 3

Back
Top