+ Reply to Thread
Results 1 to 4 of 4

Oder of operations

  1. #1
    Registered User
    Join Date
    12-21-2021
    Location
    Rutland
    MS-Off Ver
    Office 365
    Posts
    2

    Talking Oder of operations

    Hi,

    I am trying to do the following calculation


    A1 B2 C2 D2 E2
    10 -3 * 10 / 7 + 6 = 16

    Appreciate if anybody can help with multiple brackets.

    Thanks,

    Alan
    Last edited by Albert100100; 12-21-2021 at 02:33 PM.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,726

    Re: Oder of operations

    Try this:

    =(10-3)*10/7+6

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    12-21-2021
    Location
    Rutland
    MS-Off Ver
    Office 365
    Posts
    2

    Re: Oder of operations

    HI Pete,

    Unfortunately I couldn't snip my excel document, basically looking at a nested parenthesis with 5 calculations into 1 answer.

    I understand the order of operations but lost on the use of (( )).

    Thanks,

    Alan

  4. #4
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: Oder of operations

    Hi Alan,

    As a student teacher in a class of about 200 the professor asked this question: What is 2+3*4 and 80% got it wrong!!! I was a math major knowing you must multiply before you add as that is the rules for math order of operations. We don't do math, left to right!!! We do it like https://en.wikipedia.org/wiki/Order_of_operations. In some math operations you can do them forwards and backwards, ie 3+4 = 4+3 or the communitive property of addition. NOTE 3-4 <> 4-3 so it doesn't work for subtraction. In your problem you first brackets go 10-(3*10/7)+6 = ?? as you must do all multiplication and division before addition or subtraction. When you get to the 3*10/7 you can change this into an all multiplication problem by changing the "/7" into a multiply by (1/7). Multiplication is communitive so 3*10*(1/7) doesn't matter the order you do them in.

    I hope this helps - BTW I'm sure it isn't 16. I just asked Alexa what is "alexa what is 10 minus 3 times 10 divided by 7 plus 16" and she replied "approximately 11.7143"
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Macro to sort Columns in correct oder
    By Howardc1001 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-06-2020, 01:18 PM
  2. [SOLVED] Table oder by arrays
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-07-2015, 06:49 PM
  3. Lösung über Formel oder VBA
    By eugen.hasilbach in forum Excel General
    Replies: 9
    Last Post: 02-17-2015, 09:18 AM
  4. [SOLVED] Excel VBA Kopierern durch .Workbooks. .. oder .Windows. .. OOP
    By Doc.AElstein in forum Non English Excel
    Replies: 1
    Last Post: 10-03-2014, 06:26 AM
  5. Excel VBA Kopierern durch .Workbooks. .. oder .Windows. .. OOP
    By Doc.AElstein in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-23-2014, 07:41 PM
  6. Replies: 0
    Last Post: 01-29-2013, 06:01 AM
  7. If operations again
    By MIKE0W in forum Excel General
    Replies: 3
    Last Post: 03-24-2005, 02:51 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1