Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-30-2024, 05:45 AM
nameSandra nameSandra is offline Inserting Field Codes/Formula in Word Windows 10 Inserting Field Codes/Formula in Word Office 2016
Novice
Inserting Field Codes/Formula in Word
 
Join Date: Apr 2024
Posts: 2
nameSandra is on a distinguished road
Default Inserting Field Codes/Formula in Word

Many years ago I used formulae in Word all the time. I am now completely failing and I can't remember what I used to do. I am using Word 2016. I have gone down to the simplest formula I could think of =SUM (1,2,3). When I toggle the field codes off (ALT F9) it is though the formula hasn't been entered.
Hello {{=SUM(1,2,3)}} Try again {=SUM(1,2,3)} end



What one sees after toggling is:

Hello Try again end




The braces were entered using CTRL F9


I'm sorry as it must be something really obvious but I'd very much appreciate any help.
Reply With Quote
  #2  
Old 04-30-2024, 03:52 PM
Guessed's Avatar
Guessed Guessed is offline Inserting Field Codes/Formula in Word Windows 10 Inserting Field Codes/Formula in Word Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,995
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

I don't normally put mathematical formulas into Word and I'm not seeing Sum as a useful field unless it is inside a table.
Outside of a table you could use {=1+2+3}
Inside a table, you can use something along the lines of {=Sum(Above)} or {=Sum(Left)} or {=Sum(A2,B3,C3)}
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #3  
Old 05-01-2024, 10:17 AM
nameSandra nameSandra is offline Inserting Field Codes/Formula in Word Windows 10 Inserting Field Codes/Formula in Word Office 2016
Novice
Inserting Field Codes/Formula in Word
 
Join Date: Apr 2024
Posts: 2
nameSandra is on a distinguished road
Default Solved!

Thank you Andrew - I tried your simple {-(1+2+3} that didn't work either, then inspiration struck. I saved the document as a macro-enabled one and Hey Presto! everything worked. I can now get on and do the text manipulation I want.


If it hadn't been for your simple formula that I knew definitely should work I wouldn't have got there.
Thanks again
Reply With Quote
  #4  
Old 05-01-2024, 10:21 AM
Stefan Blom's Avatar
Stefan Blom Stefan Blom is offline Inserting Field Codes/Formula in Word Windows 11 Inserting Field Codes/Formula in Word Office 2021
Moderator
 
Join Date: Aug 2011
Posts: 3,914
Stefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to all
Default

The field code shown below would definitely display "4" after it has been updated and field codes have been hidden.

It is crucial that you add the field delimiters, { }, using the keyboard. Press Ctrl+F9 (or Ctrl+Fn+F9 on many keyboards nowadays). The presence or absence of spaces around may also be relevant to the success of your field coding.
Attached Images
File Type: png fieldCalculation.png (1.5 KB, 8 views)
__________________
Stefan Blom
Microsoft Word MVP

Microsoft 365 apps for business
Windows 11 Professional
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Inserting Field Codes/Formula in Word Word Document Invoice, and Field codes are doubling fees BCBoyInOntario Word 3 10-24-2022 02:39 PM
Inserting Field Codes/Formula in Word Word 2016 cannot hide field codes in document created by work 2013 twinclouds Word 2 03-10-2017 03:15 PM
Inserting Field Codes/Formula in Word The use of IF field codes in Word 2010 sunaina_ssl@yahoo.com.au Word 3 12-01-2015 08:54 PM
Formula Field using Field Codes hunter2193 Word 3 04-05-2013 04:58 AM
Inserting Field Codes/Formula in Word Word Equation field codes mkarthic Word 1 12-02-2011 02:09 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:39 PM.


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