display 0

J

jtinne

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
 
D

duane

=if(isna(VLOOKUP(E3,Sheet2!$A$1:$B$4,2,0)),0,A3*(D3/VLOOKUP(E3,Sheet2!$A$1:$B$4,2,0))
 
M

mathew

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
 
Top