jeudi 10 décembre 2020

Return N/A as value in a MINIFS function when value in a criteria range is N/A

I would like for my formula to return N/A in column G when there is an N/A in column C. The following screenshot provides my current formula:

I am using excel 2019

Image of my excel problem. Stackoverflow would not let me embed the image in the post.

If anyone has any idea about how I should change my formula I would be a very happy man. Thanks in advance.

Kind regards,

VHes

Aucun commentaire:

Enregistrer un commentaire