Please enable JavaScript.
Coggle requires JavaScript to display documents.
UNIT 3 REVISION, =Hlookup(J15,Cell:Cell,2,0) - the same as vlookup -…
UNIT 3 REVISION
Functions
: :
-
=sumif(cell:cell,"Shoes (value any type of things that you are searching for),cell(things you are searching for):cell
-
-
-
-
=vlookup(D5,D13:E17,2,0) 1, approximate , 2 - exact amount
-
-
-
Chart/Graph
functions
Pie chart : Pie charts commonly used in dashboard reports, and are great for creating an overview of underlying items
-
-
-
-
Operators
Functions
-
-
*= multiply , calculate percentage
-
-
,= combined 2 multiple references into 1
=Hlookup(J15,Cell:Cell,2,0) - the same as vlookup
-
-
-