Sat 18 Jun 2016

Article 40 - Order of Operations in Formula

By |Saturday, June 18th, 2016|Categories: Articles|Tags: , , , , , , , , , , , , , , |0 Comments

Follow the BODMAS rule

B – Brackets (Parentheses)
O – Orders (Powers/Exponents)
D – Division
M – Multiplication
A – Addition
S – Subtraction (more…)

Mon 13 Jul 2015

Solution - Challenge 4 – SUM of Multiplication of Preceding Digits by Succeeding Digits

By |Monday, July 13th, 2015|Categories: Solutions|Tags: , , , , , , , , , , |0 Comments

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

Challenge 4 - SUM of Multiplication of Preceding Digits by Succeeding Digits

By |Saturday, November 29th, 2014|Categories: Challenges|Tags: , , , , , |1 Comment

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

1

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