Last answered:

09 May 2023

Posted on:

25 Apr 2023

1

No error for last formula

When I used the fomula =Sales12+Sales13, it did not produce an error.  Instead, it added each row and provided the values:

26

6.7

5.4

21.4

 

all in a column.  Shouldn't it produce an error?

2 answers ( 0 marked as helpful)
Instructor
Posted on:

25 Apr 2023

0

Hi Emmanuel,

I would have expected the same. Perhaps your Excel version is newer and something changed. Do you want to share a screenshot?

Best,

Ned

Super learner
This user is a Super Learner. To become a Super Learner, you need to reach Level 8.
Posted on:

09 May 2023

0

Hi Ned!
Thanks for the great lessons!
I have the same thing as Emmanuel:

Let's say Sales12 = [1, 2, 3] and Sales13 = [3, 4, 5]
Then the expression (Sales12 + Sales13) results in [4, 6, 8]
=> So, it gives the sum element by element: [1st + 1st, 2nd + 2nd, 3rd + 3rd]

Submit an answer