Please enable JavaScript.
Coggle requires JavaScript to display documents.
UNIT 20 - Coggle Diagram
UNIT 20
FORMULAE AND FUNCTIONS
-
-
-
-
-
=ROUND(B2,0), takes the content of cell B2 and rounds the number to 0 decimal place
-
COUNTA: works in similar way as Count function. This function counts the number or text values displayed in a cell =COUNTA(A2:A19)-COUNT(A2:A19)
COUNTIF: looks at the cells within a given range and counts the number, text, inequality or a cell reference.
IF: contain a pair of brackets and, within the brackets, three parts, each separated by a comma.
=IF(A1=5, A2*0.05,"No discount")
SUMIF: works in a similar way to COUNTIF. It compares each value in a range of cell and, if the value matches the given condition, it adds the value in another related cell to form a running total
LOOKUP: used to lookup a value using data in the first row or the first column of a range cells and returns a relative value.
-
DEFINITION
Absolute cell reference: a cell address which does not change when the formula is copied to a new cell
-
-
-
-
-
-
A model prepared needs to be tested before being used to ensure that all results computed are accurate. The test plan must be justified to be apt for the model. E.g. all the mathematical operations must be tested in a model that relies on calculations.
-