#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
How do you know how to reference which cells?
|
#4
|
|||
|
|||
Press Force (kN) Reference Standard Machine Display Deviation Disposition 1 3 !Syntax Error, : ☐ Marginal ☐ Unacceptable 2 (mid range) =ABS(B3:C3) is whats above |
#5
|
|||
|
|||
This is what I have and it is not working.
|
#6
|
|||
|
|||
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
|
||||
|
||||
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 | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Calculating age on a Word Document | arojo1976 | Word | 7 | 10-04-2018 05:16 PM |
Absolute Value Size Consistency | bdavidson40 | Word | 4 | 08-28-2017 03:48 AM |
Calculating Tax in Word Doc | DORFER | Word | 4 | 12-21-2016 08:21 PM |
issue in calculating field in word fillabel form | expert4knowledge | Word | 2 | 12-07-2014 05:23 PM |
Calculating Form Fields in Microsoft Word | wubba80 | Word | 1 | 06-25-2010 12:42 AM |