Drop down, fill in + calculation

%3CLINGO-SUB%20id%3D%22lingo-sub-2499509%22%20slang%3D%22en-US%22%3EDrop%20down%2C%20fill%20in%20%2B%20calculation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2499509%22%20slang%3D%22en-US%22%3EHere%20is%20what%20I%20am%20trying%20to%20do.%20I%20would%20like%20to%20have%20a%20sentence%20that%20at%20the%20end%20would%20have%20a%20drop%20down%20with%20the%20following%20options%3A%20from%20%24500.00%20by%20%24200.00%20to%20%24300.000%20or%20the%20person%20using%20the%20form%20can%20select%20from%20the%20drop%20down%20%E2%80%98unchanged%20at%20%24xx.xx.%E2%80%99%20I%E2%80%99ve%20figured%20out%20how%20to%20make%20the%20former%20possible%2C%20but%20not%20in%20a%20drop%20down%20with%20choices.%20I%20would%20also%20like%20to%20have%20it%20so%20that%20if%20one%20enters%20a%20negative%20number%20after%20the%20By%20that%20it%20will%20subtract%20that%20amount%20from%20the%20from%20and%20the%20result%20appear%20after%20the%20to.%20Alternatively%2C%20I%E2%80%99m%20open%20to%20having%20a%20drop%20down%20option%20for%20remains%20unchanged%20and%20then%20a%20from%20%24%20by%20%24%20to%20%24%2C%20whereby%20one%20option%20does%20addition%20and%20the%20other%20subtraction.%20The%20numbers%20I%20used%20above%20are%20for%20illustration%20purposes%20only.%20Any%20guidance%20is%20appreciated.%20The%20path%20of%20least%20resistance%20is%20preferred.%20Thanks!%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2499509%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EWord%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2513909%22%20slang%3D%22en-US%22%3ERe%3A%20Drop%20down%2C%20fill%20in%20%2B%20calculation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2513909%22%20slang%3D%22en-US%22%3EBump.%3C%2FLINGO-BODY%3E
New Contributor
Here is what I am trying to do. I would like to have a sentence that at the end would have a drop down with the following options: from $500.00 by $200.00 to $300.000 or the person using the form can select from the drop down ‘unchanged at $xx.xx.’ I’ve figured out how to make the former possible, but not in a drop down with choices. I would also like to have it so that if one enters a negative number after the By that it will subtract that amount from the from and the result appear after the to. Alternatively, I’m open to having a drop down option for remains unchanged and then a from $ by $ to $, whereby one option does addition and the other subtraction. The numbers I used above are for illustration purposes only. Any guidance is appreciated. The path of least resistance is preferred. Thanks!
2 Replies
Bump.

@Dcphl2021 

 

I know that this is not exactly what you want, but it is information that can help you to handle your request yourself.

 

Activate controls in Word

 

In the standard installation of Word 2016, you will initially not have access to the controls, which is why you have to activate their visibility first.

 

     To do this, click in an open Word document in the “File” tab on “Options” and then on “Customize ribbon”.

     Check the box next to “Developer Tools”.

 

Create drop-down list

     First, place the cursor in your Word form where the drop-down list should appear later.

     Click the Development Tools tab.

     In the Controls group, click the drop-down list icon (combo box content control).

     In the “Controls” group click on “Properties”.

 

properties

     Finally, enter the names and values for your drop-down list in the “Properties of content control elements” menu (the drop-down list must be selected during this time).

 

Add drop-down list properties

Add content control properties

 

When you have entered all the properties, click OK.

 

Should work now

 

Drop Down drop calculate 

{=Eingabe1+Eingabe2+(Multi*{ REF Dropdown1 })\#0,00}

You have to adjust it, of course

IMPORTANT: Everyone !! Create curly brackets with Ctrl + F9, change the field view with Alt + F9, update fields with F9.

 

Additional Information:

Create forms that users complete or print in Word

To create a form in Word that others can fill out, start with a template or document and add content controls. Content controls include things like check boxes, text boxes, date pickers, and drop-down lists. If you’re familiar with databases, these content controls can even be linked to data.

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.