Hello,
I need a formula on my worksheet which will display the following, based on certain conditions:
So IF J9 AND J10 are both blank then show .
IF K8 AND J9 are both blank then show .
IF K8 AND J10 are both blank then show .
IF only 1 of K8, J9 or J10 are blank then show AND
Is there a formula that could incorporate the above?
Many thanks,
Chris
Bookmarks