basic training excel - 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