Forum Discussion

MeiChan1314's avatar
MeiChan1314
Copper Contributor
Jul 11, 2021

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 format? Is there any other suitable formula can replace, Not complex but simple to understand.

 

1 Reply

  • German_Chris's avatar
    German_Chris
    Iron Contributor
    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())

Resources