Excel in the IF function how to capture what I need? Use left, right, and mid function with the if, how to capture what I need,
Using the if function, according to the building of A column, floor, library,,,,, and screenshots later; The judge if there is no mention, the show is 1, because of work reasons, the judgment of Excel to tens of thousands of article content, please the great god teach