Just when I thought I was getting better at math...

[shadowkat]

This

Post by Power 95.3.

made me scratch my head.


7 + 7 divided by 7 +7 x7 -7.

The correct answer is apparently 50.

IF you do it this way: 7+7 =14 divided by 7 =2
2 +7 = 9, 9* 7 =63, 63-7 = 56.

If you do it by calculator = 56

If you do it by Excel = 50

Apparently it is supposed to be 7x7= 49 /7 = 1, then 1+7+7 -7 = 8.
Which still makes no sense. So, it must be = 7x7/7 =1, then 7+7+7 =21 +1
Still makes no sense. I remain puzzled.

This is why I hate math.

Comments

[flake-sake.livejournal.com]

Excel is good for most stuff, but in some labs you are not allowed to use it because weirdly enough it's results are not always reproducable. If you transfer files between computers, the data can change depending on settings.

For some uses in the pharmaceutical industry it's explicitly forbidden to keep the records in excel for this reason.

You can make it round correctly, but its a bit of procedure for such a simple thing.

[shadowkat67.livejournal.com]

I've discovered that as well. In my industry it's fine - procurement of railroad environmental engineering, construction and consulting services. But I've had to double check it on the rounding and had to turn off the rounding feature. Often the consultants that I negotiate with - don't do this, which means their figures are always slightly off.

That's why I think it's important to understand the calculations that EXCEL is completing so you can do it separately if required. Between you, catcuswatcher, and my cousin, I finally understood why 50 was the correct answer. Thanks for that by the way.