Page 1 :
© Division-forwardslash (/), ®& Multiplication asterisk *), ® Exponentiation -caret(~), Percentage -Percentsign (%), , Arithmetic Operators oe, 'A formula constituted with different mathematical operators 1S evaluated in the following, , , , order of precedence:, Highest, %, , , , Operators at the same level of precede, to right in an expression. To change the or, of the parenthesis (), as that part gets the highest priority in an expression., , e.g.,a formula = 6 + 8/2will equal 10., , whereas the same formula with parenthesis, written as (6 + 8) /2will equal 7., , nce are calculated in their order of existence from left, der of evaluation in an expression, you can make use, , Entering Formula, Formulas must begin with the '=' symbol followed by cell references and operators. Let us, Jearn more about writing formulae here. i, Basic formulas involve only one operator. Let, us calculate the sum of the numbers in cells B2, &, B3, B4, BS and display the result in B6. i" a, Follow the steps:, 1. Click on cell B6 where you want to, display the total. Type, , , , 2, Click on cell B4. Its address will appear in, , cell B6, Type'+' after that,, , Further, repeat the steps till BS or Type, B2+B3+B4+B5 in B6., , , , , , 24, , , , Press the Enter key. Cell B6 will display, the total of all the values from B2 to BS., , , , While t, task is dons, , Somec, , , , Asimp, , , , Refer, Relatiy, , Absolu, , Mixed, , , , Mixed