Please enable JavaScript.
Coggle requires JavaScript to display documents.
UNIT 20=SPREADSHEATS (COMPLEX FUNCTIONS (ROUND FUNCTION (=ROUND(B10,0), IN…
UNIT 20=SPREADSHEATS
COMPLEX FUNCTIONS
-
-
-
-
-
ROUND FUNCTION
-
IN BRACKET FIRST BLOCK FOR THE CELL THAT NEEDS TO BE ROUND THEN COMMA AND NUMBER TO INDICATE HOW MANY DECIMAL PLACES IS NEEDED TO BE ROUNDED
-
-
-
-
LOOKUP FUNCTIONS
-
VLOOKUP=VERTICLE LOOKUP
=VLOOKUP (B3, $J$3:$K$9, 2, FALSE)
=VLOOKUP(Cell to use within the comparison to the cell range
Range of cells to compare with cell B3 ,Tells Excel to look in the 2nd column of the given range,Forces an exact match when comparing)
-
-
-
-