What is the order of precedence for Excel operators?

1.	What is the order of precedence for Excel operators?
Answer» Order of operator precedence states that in MS Excel MULTIPLICATION takes place before addition. But we can FORCE the change in the order by USING parentheses. Example For example, 5+34 comes out to be 5+12=17 (5+3)4=8*4=32

Answer»

Order of operator precedence states that in MS Excel MULTIPLICATION takes place before addition. But we can FORCE the change in the order by USING parentheses.

Example

For example, 5+3*4 comes out to be 5+12=17

(5+3)*4=8*4=32

Discussion

No Comment Found

Related InterviewSolutions

What are the difference between SUBSTITUTE and REPLACE function in MS-Excel?
Why is VBA used in Excel?
How to sort numerically in Excel?
What is a waterfall chart in Excel?
What is pivot cache in Excel VBA?
Is there a shortcut key for AutoSum in Excel?
What is the use of subtotal function in Excel?
How do you enter a complicated formula in Excel?
What is the order of precedence for Excel operators?
How are count Counta and Countif functions different from each other?

What is the order of precedence for Excel operators?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment