|
|
|
|
#1
03-13-2021, 11:01 PM
|
|||
|
|||
Need Help w/Formula to Subtract
Using Word 365
Is it possible to add a formula to subtract Approved Line Amount - Current Exposure = Remaining Available (all in currency format)? I have attached the file for reference. Your help would be GREATLY appreciated. HELP!  Karen 
|
|
#3
03-14-2021, 04:00 PM
|
|||
|
|||
|
Thank you, Paul.
May I ask how you did this? Which control did you use and then how did you change the format to currency? Also, how do you set up the formula? Thank you, Karen
|
|
#4
03-14-2021, 04:09 PM
|
||||
|
||||
|
I used plain text content controls and a ContentControlOnExit macro to drive the process. Press Alt-F11 to access the VBA code.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word]
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Subtract from X formula? | tuix | Excel | 4 | 06-27-2019 06:03 PM |
| vba add and subtract code | phoenixmoto | Word VBA | 6 | 11-06-2018 02:06 PM |
 Subtract value if cell contains X term
|
Jue92 | Excel | 4 | 11-01-2016 01:45 AM |
| Subtract value from one cell into another | otuatail | Excel | 3 | 02-01-2016 03:21 AM |
| Formula to subtract one month from due date field in reminder field | ghumdinger | Outlook | 1 | 10-01-2011 12:09 AM |
Windows 7 64bit 
Office 2010 64bit
Hybrid Mode