Thread: [Solved] Help required in working out the order of precedence in formulas
View Single Post
 
Old 05-23-2022, 08:20 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 873
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
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