What are the order of evaluation in excel?

Answer 1

1. Anything in parentheses, regardless of where they are in the formula. If you have nested () then the innermost set is first

2. Anything that has exponents (^)

3. Multiplication (*) and division (/); performed in the order they are in the formula (left to right)

4. Addition (+) and subtraction (-); following the same rules as multiplication and division (left to right)

Also, if you have a formula that has both percent and exponentiation operators, the percent operators are done first and then the exponentiation operators

Examples:

3+4*5 = 23

Comment: (4*5 = 20 +3)

(3+4)*5) = 35

Comment parentheses is done first (3+4 = 7) 7*5 is 35

3^2+4*5 = 29

Comment: 1. 3 squared is first (9); 2. then the multiplication (20) then; 3. 9+20 = 29

(3^2+4)*5 = 65

Comment: 1. Exponent first 3 squared (9); 2. Parentheses next (9+ 4 = 12); and then the rest (12 * 5 = 65)

(4^2+3/10*30)-10 = 96

Comment: 1. The contents of the () are first: a. 4 squared (16); b. 3/1 is next (remember multiplication and division are done in the order from left to right); c. 3*30 (90) is next; d. so a recap we now have (16+90)-10 so the last step in the () is 2. 106 - 10 which is 96 (WHEW)

Last one: (4^2+3)/10*(30-10) =

Comment: 1. First group is: a. 16; and b. 16+3 is 19; 2. Second () is 20; 3. 19/10 is 1.9; 1.9*20 = 38