vendredi 5 juin 2020

I am using the following excel formula but want the “0” hidden

The formula below returns the correct value and removes the #NA but not the null values.

How do I remove “0” null?

=IFERROR(INDEX('[request.xlsm]Notes'!$A:$K,MATCH($C2,'[request.xlsm]Notes'!$B:$B,0),11),"")

Aucun commentaire:

Enregistrer un commentaire