98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Add another option into the existing Excel Formula | Excel forum
Add another option into the existing Excel Formula | Excel forum
Resolved · Medium Priority · Version 365
Thu 17 Apr 2025, 11:03Delegate Helen said...
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.
Thu 24 Apr 2025, 10:49Trainer Martin said...
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)
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Page Break Preview in Excel 2010 (Hint/tip)If you select View then Workbook Views then Page Break Preview, you will be able to view how your Excel spreadsheet will be split across multiple pages when printed. Even better, you can also drag a page break to a new place. Excel will then scale down your entire worksheet to fit the information you want on the pages you want. |
