I can write a basic conditional formula such as =IF(A1="23", "OK", "NOT OK"), but I want to add a supplementary condition ...
For example if A1 is 23 and B1is 24 then the cell will display OK or NOT OK as appropriate... both conditions need to be met.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!