display 0

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Here is my formula:
=A3*(D3/VLOOKUP(E3,Sheet2!$A$1:$B$4,2,0))
If there isn't a value in one of the other cells it's using for the
calculation it displays #N/A, how do I get it to display 0 instead?

Thank You
 
=if(isna(VLOOKUP(E3,Sheet2!$A$1:$B$4,2,0)),0,A3*(D3/VLOOKUP(E3,Sheet2!$A$1:$B$4,2,0))
 
Hi jtinne,
=IF(ISERROR(A3*(D3/VLOOKUP(E3,Sheet2!$A$1:$B$4,2,0))),0,A3*(D3/VLOOKUP(E3,Sheet2!$A$1:$B$4,2,0)))
Mathew


Here is my formula:
=A3*(D3/VLOOKUP(E3,Sheet2!$A$1:$B$4,2,0))
If there isn't a value in one of the other cells it's using for the
calculation it displays #N/A, how do I get it to display 0 instead?

Thank You
 
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

Please suggest any formulae / functions 2
#VALUE error add'g formulas 1
Multiple condition if statement 5
Excel Help to copy information from one row at a time to another sheet 1
#N/A 1
SUMIF or IF to display number of days or N/A 4
Display only unique values in CONCATENATE formula 4
same formula different result 3

Back
Top