basic training excel - advanced formulas and or

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » basic training excel - Advanced Formulas AND, OR

basic training excel - Advanced Formulas AND, OR

resolvedResolved · Low Priority · Version Standard

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.

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

 

Training courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Hide separate columns in Excel 2010

If you want to hide columns not adjacent to each other for example, Columns A, C and E then:-

1) Click on the fist column to be hidden i.e. A

2) Press and hold down the CTRL key

3) While holding the CTRL key, left click on the rest of the columns you want to hide i.e. C and E

4) Right click and choose Hide

View all Excel hints and tips


Server loaded in 0.13 secs.