## Article 40 - Order of Operations in Formula

Follow the **BODMAS** rule

**B** – Brackets (Parentheses)

**O** – Orders (Powers/Exponents)

**D** – Division

**M** – Multiplication

**A** – Addition

**S** – Subtraction (more…)

Sat 18
Jun 2016

Follow the **BODMAS** rule

**B** – Brackets (Parentheses)

**O** – Orders (Powers/Exponents)

**D** – Division

**M** – Multiplication

**A** – Addition

**S** – Subtraction (more…)

Mon 13
Jul 2015

Below is a possible solution to the challenge -Challenge 4 – SUM of Multiplication of Preceding Digits by Succeeding Digits

Given your numerical string is in A1, use following formula -

=IFERROR(SUMPRODUCT((MID(A1,ROW(INDIRECT("1:"&LEN(A1)-1)),1)*MID(A1,ROW(INDIRECT("2:"&LEN(A1))),1))),0)

The answer would be as follows

Sat 29
Nov 2014

Let's say you have a number 64934 in a cell A1. Now, the challenge before you is to work out the following SUM through a formula which should be flexible enough to capture any number of digits (Don't limit this to 15 digits maximum as allowed by Excel precision but to any number of digits as numbers can be entered in text also bypassing 15 digits limit of Excel)

= First Digit x Second Digit + Second Digit x Third Digit +...........+Last Digit x 0 (Last digit wouldn't be multiplied by something else as there is no succeeding digit)

The samples cases are given below for better clarity

Note - You may choose to post the response in comments section.