Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
487 views
in Technique[技术] by (71.8m points)

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

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

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

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

enter image description here

Then in Sheet1 I can reference those names in forumla

enter image description here


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...