I have the function below in a cell that I'm trying to understand, but the person who wrote it no longer exists in our company.
Here it is:
IF((M5="I")*OR(M4="P"),"",IF($M$6<40,1,ROUNDUP(M6/40,0)))
The * before the OR has me confused. Is it a wildcard or is it creating an AND/OR statement or is it an XOR.
I have cell M5 that will accept an I or E, and a cell M4 that accepts a P or E, and then the above function goes to work, except it only leaves the cell empty when both the letter I and P are in their respective cells. So it acts more like an AND statement. It sure is a complicated way to do an AND, so I'm wondering if it does more than just AND?
Please assist.
Here it is:
IF((M5="I")*OR(M4="P"),"",IF($M$6<40,1,ROUNDUP(M6/40,0)))
The * before the OR has me confused. Is it a wildcard or is it creating an AND/OR statement or is it an XOR.
I have cell M5 that will accept an I or E, and a cell M4 that accepts a P or E, and then the above function goes to work, except it only leaves the cell empty when both the letter I and P are in their respective cells. So it acts more like an AND statement. It sure is a complicated way to do an AND, so I'm wondering if it does more than just AND?
Please assist.