Forum Discussion
why MINIFS do not return blank
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 fo...
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())
You can combine your formula with an additional IF() …
IF(MINIFS(…) = 0, „“ , MINIFS())