formula - Google Sheets. Is it possible to give a word a value?

Question

I want to give words number values.

Eg. Monthly =12, Quartly = 4

What are some ways I can do this?

Thanks.

question from:https://stackoverflow.com/questions/65660313/google-sheets-is-it-possible-to-give-a-word-a-value

Answer 1

you can use the Named Range feature to name a cell. They can be in another sheet even (not another document, another sheet in the same document)

Steps

1. In the menus Click Data and then Named ranges. A menu will open on the right.
2. In a cell type 12
3. Select the cell with 12 in it
4. Click "Add Range" on the right
5. Type Monthly for the name
6. Click Done

Repeat the steps 2 to 6 for Quarterly

Now in some other cell (even on another sheet in the same document) type =Monthly in a cell or =Quarterly or Use those names in formulas

See docs

Here's a screenshot. I created a sheet called constants and typed 12 and 4 in 2 cells. I've named the first cell Monthly and the 2nd cell Quarterly

Then in Sheet1 I can reference those names in forumla