Need to get rid of "N/A"

[thewiseguy]

How would I get rid of the "N/A" value and replace it with "0?"


=P14*(S14*T14)+R14


thanks!

 

[Andrew Poulsom]

Which of those cells can contain #N/A?

 

[thewiseguy]

Which of those cells can contain #N/A?

P and R

 

[thewiseguy]

maybe the better question is: how do i get this formula to return a "0" value instead of N/A:


=VLOOKUP(E29,LABOR1,11,FALSE)

 

[Jonmo1]

The general context to eliminate N/A is

=IF(ISNA(originalformulahere),"",originalformulahere)

so for your example
=IF(ISNA(VLOOKUP(E29,LABOR1,11,FALSE)),"",VLOOKUP(E29,LABOR1,11,FALSE))

 

[Andrew Poulsom]

Try:

=IF(OR(ISNA(P14),ISNA(R14)),0,P14*(S14*T14)+R14)

 

[thewiseguy]

Excellent! thank you guys.

 

[thewiseguy]

does the same formula work for #DIV/0!? I tried it and the formula works but I cant get the #DIV/O! out of there.

 

[Jonmo1]

change ISNA to ISERROR (this will cover ANY error message)

 

[thewiseguy]

change ISNA to ISERROR (this will cover ANY error message)

still getting the DIV/O! error.