Clear #N/A

[craigwojo]

How can I make the cell seem empty (blank cell) that has a formula in it still with it showing #N/A?

Thank you and God bless,
Craig

 

[Joe4]

You can use the ISERROR formula to hide errors (see: MS Excel: How to use the ISERROR Function (WS, VBA)).

So you could do something like:
=IFERROR(your formula,"")

 

[Fluff]

You can wrap the formula in an IFERROR like
=IFERROR(your formula,"")

 

[craigwojo]

For example, here is the formula I have. When I add the IFERROR, I get an error.

=VLOOKUP(E17,Sheet2!$A$1:$C$14,2,0)*IF(M17="YES",1.1,1)

 

[Fluff]

It would be

=iferror(VLOOKUP(E17,Sheet2!$A$1:$C$14,2,0)*IF(M17="YES",1.1,1),"")