Page 1 of 1

Connect an input list to a formula

PostPosted: Tue Feb 12, 2019 11:22 pm
by ibelin123
How can I connect an input list with another formula?

I want to choose a value from "input list" then use this value in a formula.

Example: I'll choose a value from input list "Choice". Next I want put it in formula "=choice * 10".

Thank you.

Re: Connect an input list to a formula

PostPosted: Wed Feb 13, 2019 12:07 am
by RusselB
Welcome to the Forums.

Are you sure you want or need to do this in Writer? This is simple in Calc, but Writer has limited capabilities for this type of processing.

In Calc you would create a dropdown list for Choice in (for example) A2, then the formula
Code: Select all   Expand viewCollapse view
=A2*10
in the cell where you want your result. Note: This can't be cell A2, since A2 contains your dropdown list.

Re: Connect an input list to a formula

PostPosted: Wed Feb 13, 2019 12:29 am
by ibelin123
wow! Thank you for the fast reply! But yes. I want to do it in writer as this is more of a technical document. I have managed to do this with an "input field" but not with an "input list."