Search code examples
openoffice.orgopenoffice-calc

Openoffice.org Calc - Assigning value to variable

I am trying to assign a value to a variable.
For example, I want "apple" to equal "$0.05". So if I type in this formula (=apple*5) into a cell, it should return "$0.25".
I've been on YouTube and ran a search on this site, but I could not find anything that relates to what I am trying to accomplish. Any help would be appreciated.

Solution

  • Update:

    At least as of LibreOffice 24.2 (possibly earlier), this is achieved with Sheet > Named Ranges and Expressions > Define:

    enter image description here

    Old Answer:

    You can do this under Insert > Names > Define - just use the constant 0.05 when assigning the name. You can always format the cell you use it in as currency.

    enter image description here