How to show blank or nothing instead of #NUM! sign.

**adamsj1** · 09-24-2014, 04:32 AM

I have the following formula where if it doesn't match it shows #NUM! and I would like it to show nothing at all, if possible I would also like it to be blank if = 0:

=IF($B$1="outgo";INDEX(OUTGO!BV$28:BV776;MATCH('P&L'!$B20;OUTGO!$D$28:$D776;0));INDEX(INTAKE!BV$28:BV776;MATCH('P&L'!$B20;INTAKE!$D$28:$D776;0)))

Many thanks for your help.

**NeedForExcel** · 09-24-2014, 04:34 AM

Try Using =Iferror!

Let me know I you need any help!

Deep

**Olly** · 09-24-2014, 04:35 AM

try:

Formula:

Please Login or Register  to view this content.

**Big Chris** · 09-24-2014, 04:36 AM

I generally surround such things with =IF(ISERROR(YOURFORMULA)=TRUE,"",YOURFORMULA)

You'll see that there are functions like ISNA and ISREF which picks up those errors, but ISERROR appears to cover all such errors/input messages.

Keeps things tidy!

Chris.