Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-23-2022, 02:45 AM
Jules90 Jules90 is offline Help required in working out the order of precedence in formulas Windows 8 Help required in working out the order of precedence in formulas Office 2013
Novice
Help required in working out the order of precedence in formulas
 
Join Date: Apr 2019
Posts: 22
Jules90 is on a distinguished road
Question Help required in working out the order of precedence in formulas

Hi,


Iím learning about formulas and the order of operations. I know that whatever is in parentheses takes highest precedence, and if there are more than one set of parentheses in a formula, you work from the innermost set and work out.

Iíve come across an example containing an exponent, along with other mathematical operators, and want some help in determining the order in which to calculate the formula.

The example formula is: =(4 to the power of 2+3/1*30)-10
Starting with whatís inside the parentheses:
1. 4 to the power of 2 = 16
2. 16/1 = 16 (working from left to right)
3. 16*30 = 480
4. 480+3 = 483
5. Finally outside the parentheses 483-10 = 473

Would this be the correct order? Thanks in advance.
Cheers
Reply With Quote
  #2  
Old 05-23-2022, 03:08 AM
Debaser's Avatar
Debaser Debaser is offline Help required in working out the order of precedence in formulas Windows 7 64bit Help required in working out the order of precedence in formulas Office 2010 32bit
Competent Performer
 
Join Date: Oct 2015
Posts: 188
Debaser is on a distinguished road
Default

The simplest method is to put the formula in a cell, then click the Evaluate Formula button on the Formulas tab, you will then be able to step through the evaluation sequence.

But no, that is not the correct order for the formula you posted. The answer should be 96...
Reply With Quote
  #3  
Old 05-23-2022, 05:03 AM
Jules90 Jules90 is offline Help required in working out the order of precedence in formulas Windows 8 Help required in working out the order of precedence in formulas Office 2013
Novice
Help required in working out the order of precedence in formulas
 
Join Date: Apr 2019
Posts: 22
Jules90 is on a distinguished road
Default

Many thanks for your reply. I've entered the formula as you've outlined here, and come to 96 as the result.
Clicking on the Evaluate Formula button and being able to see each step in order was a great help...thanks for bringing this to my attention which will help me immensely in the future.. Cheers
Reply With Quote
  #4  
Old 05-23-2022, 08:20 AM
ArviLaanemets ArviLaanemets is online now Help required in working out the order of precedence in formulas Windows 8 Help required in working out the order of precedence in formulas Office 2016
Expert
 
Join Date: May 2017
Posts: 703
ArviLaanemets is a name known to allArviLaanemets is a name known to allArviLaanemets is a name known to allArviLaanemets is a name known to allArviLaanemets is a name known to allArviLaanemets is a name known to all
Default

The formula looks like
=(4^2 + 3/1*30)-10
Calculating step-wise:
=(16 + 1/3*30)-10;
=(16 + 3*30)-10;
=(16 + 90) -10;
=109 - 10 = 96

In case different result was excepted, the formula must be changed!
Reply With Quote
  #5  
Old 05-24-2022, 12:57 AM
Jules90 Jules90 is offline Help required in working out the order of precedence in formulas Windows 8 Help required in working out the order of precedence in formulas Office 2013
Novice
Help required in working out the order of precedence in formulas
 
Join Date: Apr 2019
Posts: 22
Jules90 is on a distinguished road
Default

Thanks for your reply. The Evaluate Formula button is a great help in figuring out what parts of the formula to evaluate first, second etc. With lots of practice it will get easier! I appreciate both of you replying and giving me your help with this...
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I paste items in the order they were copied, not the order the are listed? manish500 Word 6 07-25-2018 12:07 AM
Pasting new data and formulas stop working ehmo Excel 4 07-10-2017 01:58 AM
Suggestion required domex Word 0 10-06-2010 05:35 AM
Urgent Help Required id12345 Word 4 12-29-2009 08:22 AM
"No response required" not working!!! HellRazor Outlook 0 12-16-2008 11:58 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:50 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft