Please enable JavaScript.
Coggle requires JavaScript to display documents.
Excel - If and or - Chapter 3 - Coggle Diagram
Excel - If and or - Chapter 3
IF - Formula
Condition
Used to stipulate whether you wish to compare values in different cells, or compare a cell value with a particular conditional statement
E.g. A1=B5 or A1>50
In the above example you would test whether the inventory quantities are lower than 50, in other words: A2<50
True action
If the condition is True, then the action contained in the true action statement will be executed
If the inventory quantity is lower than the minimum amount you will display a warning
=if(condition, true action, false action)
False action
If the condition is false, then the action contained in the false-action statement will be executed. The false-action statement is optional
If the inventory amount is still higher than the minimum amount you can either display false, or leave the cell empty
The IF formula is used when you want certain actions to be performed under specific conditions
AND - Formula
=AND(argument1, argument2, argument3,....)
E.g The students pass when all 3 tests, as well as the average, are greater than 49
Content: +AND(D3>49,E3>49,F3>49,G3>49)
Display value: FALSE
The and formula executes 2 or more tests and if all the arguments have been satisfied, the word true will be displayed otherwise false
OR - Formula
=OR(argument1, argument2, argument3,....)
E.g. the students pass when any one of the 3 marks or the average is greater than 49
Content: OR(D3>49,E3>49,F3>49,G3>49)
Display value: TRUE
The or formula executes 2 or more tests and if one or more of the arguments have been satisfied, the word true will be displayed, otherwise false
IF, AND, OR combinations
E.g. The students pass when any one of the 3 marks is greater than 49 and the average is greater than 45
Content: AND(OR(D3>49,E3>49,F3>49),G3>45)
Display value: TRUE
E.g. If students pass, display the word "PASS". The students pass when any one of the 3 marks is greater than 49 and the average is greater than 45
Content: IF(AND(OR(D3>49,E3>49,F3>49),G3>45),"PASS")
Display value: PASS
IF, AND, OR formulas can be combined