Forum home » Delegate support and help forum » Microsoft Excel Training and help » Nested If and And
|
|
|
The UK's most regular 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. |
Nested If and And
Resolved · Low Priority · Version 2003
Reply Wed 8 Oct 2008, 15:29Delegate James said...
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'
For upcoming training course dates see: Pricing & availability
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
|