This preview shows pages 1–2. Sign up to view the full content.
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

Click to edit the document details