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 » Nested If and And
Nested If and And
Resolved · Low Priority · Version 2003
James has attended:
Excel Advanced course
Nested If and And
Please give an example of a formula that includes 'if' and 'and' and 'if' and 'or'
RE: Nested If and And/OR
Hi James,
Thank you for your question.
Enjoy the following example:
=IF(AND(B7>25000,C7>15000),"Yes","No")
This example returns the answer of Yes or No depending on whether both sets of criteria match. If one matches and not the other then No will be returned. If both match then Yes will be returned.
=IF(OR(B7>25000,C7>15000),"Yes","No")
This example returns the answer of Yes if any one of the criteria is matched and will only return No when both criteria do not match.
I hope this answers your question.
Regards
Simon
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:Keyboard Shortcuts to Add Rows or ColumnsCouple of other keyboard shortcuts. Shift+spacebar selects a row, Ctrl+spacebar selects a column. Select either row or column (or several) and use Ctrl and + to insert or Ctrl and - to delete rows or columns. |