Basic Excel Formulas 2

Ask a question

We saw the SI function

Function and is also interesting. Combined with SI, this gives:

= IF (AND (condition1; condition2 ;....... conditionZ) true false)
displays on the various conditions to be verified (eg B3> C2 .... B9 = C2, etc. ..).
if all conditions are met, the result is true, otherwise the result is false.

you can use these results as arguments for other forms or directly enter a value, eg
= IF (AND (B3 <100 B3> 200, C1 = "yes"); "value out of range ";"")
this formula:
- Verify that the value entered in B3 is between 100 and 200
- Verify that cell C1 contains the word yes
- Inscribed "Value out of range" if B3 is <100 or> 200 or leaves the cell blank ( "") if B3 is between 100 and 200.

Another example:
click Format / Conditional Formatting / The formula is:
= IF (AND (B3 <100 B3> 200, C1 = "yes"); true, false)
then click Format and choose the type of display (including color of the cell) when the conditions are true.
Jean-François Pillou

CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jeff Pillou, founder of CCM reaches more than 50 million unique visitors per month and is available in 11 languages.

Learn more about the CCM team