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 rules-Any numeric or string expression or constant-Cell references-Intrinsic functions-Relational expressions, < > =, <>- not equal-Links to other worksheet Some combinations are allowed as well Formulae examples =Sheet2!A5-2 * B4-B4 =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 () Brackets-Negation % 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+A2-A3 =B4-8* ( a4^2 )-5* (-4^2 ) = SUM (A1:A3) + ( A5*4 ) = IF (A5 + ( 1*B3 ) > B4;G4;R4) Formatting cells...
View Full Document
- Spring '11
- Formulae Formulae, colour input cells, formula prefix character, String.text constants String/text, Check totals Break