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.
Update:
At least as of LibreOffice 24.2 (possibly earlier), this is achieved with Sheet > Named Ranges and Expressions > Define:
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.