Please enable JavaScript.
Coggle requires JavaScript to display documents.
Excel - Week 3 - Chapter 3 - Coggle Diagram
Excel - Week 3 - Chapter 3
Or - formula
Remember in the And formula, all conditions needed to be met in order for it to display true
E.g. =or(B4 = "spar"; B4 = "shoprite")
The or formula displays true or false, true is when one condition is met, false when none are met
Quotation marks are needed for words
When something needs to be true or something else
Spelling needs to be 100% correct
Shortcut tip
Drag down to remainder of database
Shortcut:
Just double click on the + key in the right corner
This shortcut does NOT work if there is a blank column in between
=if(B2>50; "pass"; "fail")
Ctrl + A
Selects whole database
Dragging your formula to the remainder of the database
If, and, or combinations
BUT it needs to display "cool" therefore the IF formula
=If(And(............); "cool"; "")
=And(B4 = "woolworths"; C4 = "Nestle")
Something that is between two amounts, use an and formula. (600<X<800) => write (D4>600; D4<800)
E.g. 1 Write a formula which will show "cool" when the supplier is "woolworths" and the rand is "nestle", otherwise nothing should appear
If, and, or combinations
Nestle AND >=700
=If(Or(B4 = "spar"; and(C4 = "nestle"; D4>=700)); "holiday"; "")
Spar
E.g. 2 Write a formula which would show "Holiday" when the supplier is "spar", or when the brand is "Nestle" and the price is above or equal to R700
Start from the outside in