#1
|
|||
|
|||
Sum of numbers regardless of sign in a Form Field
Hello. I have a Form Field table in Word and I'm trying to add up the total of the 3 fields, regardless of the positive or negative. In other words, I need -2000 and +2000 to equal 4,000. I have a formula that results in 0, which is my "net" but I need the "gross" if that makes sense. I tried using the "SUMIF" formula but could not get it to work properly.
I attached a sample that hopefully better explains it. Thank you in advance for any help. |
#2
|
|||
|
|||
You could use the ABS function.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel 2019: How to display the sign of numbers in another field in brackets? | Jamal NUMAN | Excel | 3 | 09-16-2021 09:44 AM |
Merging phone numbers with + sign | WibbleWobble | Mail Merge | 2 | 12-28-2019 04:29 AM |
Activate (show) a Drop-down form field when another drop-down form field is selected from | Jentis | Word VBA | 1 | 04-19-2018 09:42 PM |
Macro to autofill a form field ONLY if the form field is blank upon entry | Pindar | Word VBA | 2 | 01-12-2017 05:03 PM |
How to add the plus sign (+) automatically for the numbers which are positive? | Jamal NUMAN | Excel | 2 | 05-01-2011 03:15 PM |