Forum home » Delegate support and help forum » Microsoft Excel Training and help » basic training excel - Advanced Formulas AND, OR
|
|
|
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. |
basic training excel - Advanced Formulas AND, OR
Resolved · Low Priority · Version Standard
Reply Wed 19 Sep 2007, 14:44Delegate Ehsen said...
Ehsen has attended:
Excel Advanced course
Advanced Formulas AND, OR
Could you please post some notes on other formulas such as AND, OR to gain further knowledge of the subject.
For upcoming training course dates see: Pricing & availability
Reply Fri 21 Sep 2007, 15:41Delegate Paul said...
RE: Advanced Formulas AND, OR
AND is usually used with the if statement, such as
=if(and(A1=1,B1=1),"yes","")
that's asking excel to look at A1 and B1 and if they both are 1, then display the word yes, else display nothing.
similarly, the or statement is best used with if.
=if(or(A1<500,A1>1000),"extreme","")
this is asking excel to look at cell A1 and if it's either below 500 or above 1000, return the word extreme, else display nothing.
Hope this helps
Paul
|