Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-21-2018, 03:50 PM
tg2018_ tg2018_ is offline Order of Operations in Word Windows 10 Order of Operations in Word Office 2016
Novice
Order of Operations in Word
 
Join Date: Aug 2018
Posts: 2
tg2018_ is on a distinguished road
Angry Order of Operations in Word

I am attempting to do the following formula in a mail merge field in Word:



FORMULA IN WORD { = (1 - ((1+(2/100))*(0.995))^19)}

When I enter this formula in a Word mail merge field, I get 2.324

However, when I do the formula in excel, I get -0.3244 (the correct answer)

FORMULA IN EXCEL =(1 - ((1+2/100)*(0.995))^19)

I am driving myself CRAZY! I do not understand what in the world is going on. I believe the Excel value is correct. I have tried everything. I know Word has its peculiarities in Mail Merge and maybe this is something. I have consulted the usual sources (Graham Mayor, etc) and the forums and Google with nooooo luck. Please help!
Reply With Quote
  #2  
Old 08-21-2018, 08:29 PM
macropod's Avatar
macropod macropod is online now Order of Operations in Word Windows 7 64bit Order of Operations in Word Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Your Word and Excel formulae can both be reduced to:
=1-((1+2/100)*0.995)^19
and, with the appropriate formatting switch applied to the field in Word:
{=1-((1+2/100)*0.995)^19 \# 0.00000}
will both return -0.32447. That said, there does seem to be a bug in the Word calculation when you unnecessarily use (0.995) in the calculation; that seems to cause Word to treat the 0.995 as a -ve value.

I don't see what this has to do with a mailmerge, however, as no mergefields are involved.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 08-23-2018, 09:59 AM
tg2018_ tg2018_ is offline Order of Operations in Word Windows 10 Order of Operations in Word Office 2016
Novice
Order of Operations in Word
 
Join Date: Aug 2018
Posts: 2
tg2018_ is on a distinguished road
Default

That worked! Thank you!
Yes definitely some error on Word's part with the parenthesis issue.
This is indeed a mail-merge field, but I took it out and replaced it with 0.995 because the mail merge field itself was not an issue with the equation. Next time I post I will categorize it better. Thanks
Reply With Quote
Reply

Tags
mail merge, math, order of operations

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
Order of Operations in Word Search text using logical operations? paik1002 Word 1 02-21-2016 11:48 PM
specifying sender account for mail merge operations eNGiNe Mail Merge 3 12-19-2014 04:24 AM
HELP - SUMIF more than 3 conditions + operations in the sum romelsms123 Excel 0 06-23-2014 09:59 AM
Arabic word order SimonCramer Word 0 02-23-2012 03:02 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:01 AM.


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