This preview has intentionally blurred sections. Sign up to view the full version.
View Full Document
Unformatted text preview: “hello right justify ^hello center Testing one two =LOWER(“BOOoo”) Formulae Formulae can be composed of any of the following rulesAny numeric or string expression or constantCell referencesIntrinsic functionsRelational expressions, < > =, <> not equalLinks to other worksheet Some combinations are allowed as well Formulae examples =Sheet2!A52 * B4B4 =SUM(A1:A3_ =B2 & (concatenation operator) “BOO” =A1>4 Formulae might require a formula prefix character (e.g =,+,). This depends on the spreadsheet package being used. Operator precedence BEDMAS () BracketsNegation % percent ^ exponentiation – 2^3^2= 2^9=512 (regular math)/ 2^3^2= 8^2=64 (to get rid of it put brackets on 3^2) */ multiplication and division +  addition and subtraction Eg. +A1+A2A3 =B48* ( a4^2 )5* (4^2 ) = SUM (A1:A3) + ( A5*4 ) = IF (A5 + ( 1*B3 ) > B4;G4;R4) Formatting cells...
View
Full Document
 Spring '11
 NAKAMURA
 Formulae Formulae, colour input cells, formula prefix character, String.text constants String/text, Check totals Break

Click to edit the document details