Microsoft Office Forums > Word Calculating absolute value in word?
 Register FAQ Search Today's Posts Mark Forums Read

#1
10-09-2020, 05:48 AM
 Jayfaas Windows 7 64bit Office 2016 Novice Join Date: Aug 2018 Posts: 6
Calculating absolute value in word?

I have a word datasheet that we use at work and I am wondering if I can get it to calculate the value of two cells into an absolute value? the cells are:

Reference Machine Deviation

I would like to have it give me the absolute value between the reference and machine in the deviation cell. Is there a way to do this?
#2
10-09-2020, 09:32 AM
 Charles Kenyon Windows 10 Office 2019 Moderator Join Date: Mar 2012 Location: Sun Prairie, Wisconsin Posts: 6,923

You can use the ABS function or do it the long way with an IF field.

Note, the field delimiter braces { } must be inserted by Word, you cannot type them.
#3
10-16-2020, 05:29 AM
 Jayfaas Windows 7 64bit Office 2016 Novice Join Date: Aug 2018 Posts: 6

How do you know how to reference which cells?
#4
10-16-2020, 05:36 AM
 Jayfaas Windows 7 64bit Office 2016 Novice Join Date: Aug 2018 Posts: 6

Press Force (kN)
Test no.
Reference Standard
Machine Display
Deviation
Disposition
1 (low range)
1
3
!Syntax Error, :
Acceptable
Marginal
Unacceptable
2 (mid range)
=ABS(B3:C3) is whats above
3 (high range)
#5
10-16-2020, 05:38 AM
 Jayfaas Windows 7 64bit Office 2016 Novice Join Date: Aug 2018 Posts: 6

This is what I have and it is not working.
Attached Images
 Capture.JPG (42.0 KB, 6 views)
#6
10-16-2020, 05:50 AM
 Charles Kenyon Windows 10 Office 2019 Moderator Join Date: Mar 2012 Location: Sun Prairie, Wisconsin Posts: 6,923

Quote:
 Originally Posted by Jayfaas How do you know how to reference which cells?
This is much easier in Excel.
In word, cell references are absolute.
First row is 1, first column is a, so top left cell is a1, next column, same row, is b1.

Alternatively, you could add named bookmarks to your sources and refer to those rather than cell references.
#7
10-16-2020, 02:08 PM
 macropod Windows 10 Office 2010 Administrator Join Date: Dec 2010 Location: Canberra, Australia Posts: 20,489

To see how to do a wide range of calculations in Word, check out my Microsoft Word Field Maths Tutorial, in the 'Sticky' thread at the top of this forum:
https://www.msofficeforums.com/word/...-tutorial.html
The tutorial includes examples for doing relative cell addressing. There's even a macro in the tutorial for correctly identifying cell addresses.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post arojo1976 Word 7 10-04-2018 05:16 PM bdavidson40 Word 4 08-28-2017 03:48 AM DORFER Word 4 12-21-2016 08:21 PM expert4knowledge Word 2 12-07-2014 05:23 PM wubba80 Word 1 06-25-2010 12:42 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 02:16 PM.

 -- Default Style -- Lightweight -- New Mobile Contact Us - Privacy Statement - Top