How to disable #N/A being displayed

Hi,

In cell B10 a #N/A is being displayed because cells F10 has now value (0)

F10 is a result of multiplying D10 with E10

How do i not show the #N/A

Thanks for any help
experts-1d.xlsx
propolisAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Rory ArchibaldConnect With a Mentor Commented:
You need to change the formula in B10 (and the cells above) to:
=IFERROR(VLOOKUP(F10,Sheet2!$A$2:$C$10,3,FALSE),"")

for example. Note: you will need to disable the data validation temporarily to make the change.
0
 
CluskittCommented:
User the ISNA function:
IF(ISNA(D10*E10),0,D10*E10)
0
 
PaulNSWCommented:
you could use conditional formatting to change the cell text colour to white

use

=ISNA($cell$reference)
0
 
propolisAuthor Commented:
Hi,

Not sure how to implement this:

F10 has already a calculation in it to which cell B10 does a vlookup based on the value f10

So f10 is:   0  then the vlookup results is #N/A

Please advice and thanks for your help
0
 
CluskittCommented:
Just replace F10. It has some formula, for example, =VLOOKUP(....). Just change it to:
=IF(ISNA(VLOOKUP(.....),0,VLOOKUP(.....))
0
All Courses

From novice to tech pro — start learning today.