why MINIFS do not return blank

%3CLINGO-SUB%20id%3D%22lingo-sub-2535901%22%20slang%3D%22en-US%22%3Ewhy%20MINIFS%20do%20not%20return%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2535901%22%20slang%3D%22en-US%22%3E%3CP%3EColumn%20B%20%3D%20PO%20Date%20is%20from%20the%20category%20(Cell%20G)%20that%20written%20PO%20memo%20and%20match%20with%20material.%20Otherwise%20return%20blank%20if%20doesn't%20match.%20Its%20strange%20why%20my%20Excel%20book%20do%20not%20return%20blank%20but%20a%20date%20format%3F%20Is%20there%20any%20other%20suitable%20formula%20can%20replace%2C%20Not%20complex%20but%20simple%20to%20understand.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Minifs_2.PNG%22%20style%3D%22width%3A%20647px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F294851iE82C58030CE2867B%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Minifs_2.PNG%22%20alt%3D%22Minifs_2.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2535901%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2535922%22%20slang%3D%22en-US%22%3ERe%3A%20why%20MINIFS%20do%20not%20return%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2535922%22%20slang%3D%22en-US%22%3EMINIFS()%20delivers%200%20If%20there%20is%20no%20match%20Not%20a%20blank%20(see%20help%20from%20Microsoft)%20.%3CBR%20%2F%3EYou%20can%20combine%20your%20formula%20with%20an%20additional%20IF()%20%E2%80%A6%3CBR%20%2F%3EIF(MINIFS(%E2%80%A6)%20%3D%200%2C%20%E2%80%9E%E2%80%9C%20%2C%20MINIFS())%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Column B = PO Date is from the category (Cell G) that written PO memo and match with material. Otherwise return blank if doesn't match. Its strange why my Excel book do not return blank but a date format? Is there any other suitable formula can replace, Not complex but simple to understand.

 

Minifs_2.PNG

1 Reply
MINIFS() delivers 0 If there is no match Not a blank (see help from Microsoft) .
You can combine your formula with an additional IF() …
IF(MINIFS(…) = 0, „“ , MINIFS())