![]() ![]() This will ensure that A2 and D2 are first evaluated then divided by two. Using this rule, we can rewrite the above formula as =(A2 * D2) / 2. For arithmetic operators, the division is evaluated first followed by multiplication then addition and subtraction is the last one to be evaluated. This means expressions are brackets are evaluated first. Remember the rules of Brackets of Division, Multiplication, Addition, & Subtraction (BODMAS).Mistakes to avoid when working with formulas in Excel ![]() The following animated image shows you how to auto select cell address and apply the same formula to other rows.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |