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.
Connect an input list to a formula
Connect an input list to a formula
OpenOffice 4.1.2 on Windows 7
Re: Connect an input list to a formula
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 in the cell where you want your result. Note: This can't be cell A2, since A2 contains your dropdown list.
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
=A2*10
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
Re: Connect an input list to a formula
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."
OpenOffice 4.1.2 on Windows 7