September 2017

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

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.