98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » excel vba training - IF / OR function
excel vba training - IF / OR function
Resolved · Low Priority · Version Standard
Nick has attended:
Access Introduction course
IF / OR function
I want a formula to return a certain response if any one of several questions is answered "YES" - can you please help ?
i.e. if cellA = "Yes", or if cellB = "Yes", or if cellC = "Yes" ....... return Y
I have searched microsoft help and can't find a solution
RE: IF / OR function
Hi Nick,
Yep, it works in the similar way to the AND() function I told you about in your previous post.
Simply swap the AND() for OR(), like this:
=IF(OR(B2="yes", C2="yes", D2="yes"), "y", "n")
The OR() will return your 'if true' value (in this case "y") if ANY of the conditions listed in OR() are true. Otherwise the IF() statement will return your 'if false' value (in this case "n").
Hope this answers your question.
Regards, Rich
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:How to Remove Duplication's from a selection of data in an Excel 2010 WorksheetIt would take far too much time to scan through rows and rows of data to find and remove duplicate data. So, here's how to do this using a much more efficient method:- |