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.
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
