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: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
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