Referencing Public Constants in Cell Formulas

[drhansenjr100]

[COLOR=#BBC0C4 !important][COLOR=#6A737C !important]0
<button class="js-vote-down-btn grid--cell s-btn s-btn__unset c-pointer" title="This question does not show any research effort; it is unclear or not useful" aria-pressed="false" aria-label="down vote" data-selected-classes="fc-theme-primary" style="margin: 2px; box-sizing: inherit; font: inherit; position: relative; padding: 0px; border-width: initial; border-style: none; border-color: initial; border-radius: 3px; background-image: none; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; outline: none; box-shadow: none;"><svg aria-hidden="true" class="svg-icon m0 iconArrowDownLg" width="36" height="36" viewBox="0 0 36 36">
</path></svg></button><button class="js-favorite-btn s-btn s-btn__unset c-pointer py8" aria-pressed="false" aria-label="favorite" data-selected-classes="fc-yellow-600" title="Click to mark as favorite question (click again to undo)" style="margin: 0px; box-sizing: inherit; font: inherit; padding: 0px; position: relative; border-width: initial; border-style: none; border-color: initial; border-radius: 3px; background-image: none; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; outline: none; box-shadow: none;"><svg aria-hidden="true" class="svg-icon iconStar" width="18" height="18" viewBox="0 0 18 18">
</path></svg>
</button>[/COLOR]
[/COLOR]
I would like to be able reference a public constant in a cell formula. I have found multiple references to defining constants from cell values, but not for using constants in formulas.
I would like to be able do something like this (I know that this is not the right syntax, but you get the idea...)
<code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; vertical-align: baseline; box-sizing: inherit; white-space: inherit;">="Some formula text " & myPublicConstantName</code>Ideas?
Thanks!

 

[sijpie]

There are a few things you can do and a few things you can't do.

When you are talking about formulas used in Excel, like =SUM(A1:B4) you cannot reference public constants as defined in a VBA project in that workbook.

However, you can set up a small range (in your sheet or in a separate sheet) where you enter your constants, and give each cell a name. Now you can reference that name in your formula.

So if G2=3.28 and you give G2 the name m2ft, then you can use this in your formulas to convert meters to ft or vice versa
so in A2 you can have
=A1*m2ft
to get the value in A1 as ft in A2.

Excel will even show your constants when you start typing their names

Is this what you meant?