Helen has attended:
PowerPoint Intermediate Advanced course
Add another option into the existing Excel Formula
The current formula is below:
=IF(A3="Do Not Use","Do Not Use",IF(AND(B3="Chas Approved",Q3>$O$1,W3="Valid",OR(AA3="Valid",AA3="N/A")=TRUE),"Current","OutofDate"))
I would like to add "HQ Approved" into the formula. So, if Chas Approved OR HQ Approved are selected in the drop down, the same action happens.
Please let me know how to add HQ Approved into the formula.
RE: Add another option into the existing Excel Formula
Hi Helen,
Thank you for your question to the forum.
To add "HQ Approved" in the formula, assuming it is based on the same drop down on B3, the formula should read:
=IF(A3="Do Not Use","Do Not Use",IF(AND(OR(B3="Chas Approved",B3="HQ Approved"),Q3>$O$1,W3="Valid",OR(AA3="Valid",AA3="N/A")=TRUE),"Current","OutofDate"))
I hope this gives you the correct answer
Kind regards
Martin Sutherland
(IT Trainer)
