Kuliah 10. Conditional Function Please have your note on hand! What is a formula in Excel definition? In Microsoft Excel, a formula is an expression that operates on values in a range of cells . These formulas return a result, even when it is an error. Excel formulas enable you to perform calculations such as addition, subtraction, multiplication, and division. Excel has over 475 formulas in its Functions Library, from simple mathematics to very complex statistical, logical, and engineering tasks such as IF statements (one of our perennial favorite stories); AND, OR, NOT functions; COUNT, AVERAGE, and MIN/MAX. Mar 11, 2020 Column x Row è Cell . A group of cells è range Formula è Arithmatics, Logics, Strings (Text), Statistics, Database etc typed in a cell or range Syntax begins with = (eq sign). Example è = D2 + E2 Consists of operators, functions , numeric, text etc Cell Reference è ( Relative and Absolute ) By default, a cell reference is a rel...