Cell reference vs Range names

#1

Rather than a range name to embed in a particular text I would like just to reference just one specific cell within the range. However, when I do that, e.g. {{b1}} the sim returns “Null” in the text when it runs. Is it possible to reference one particular cell and that such information is permanent?

#2

Hi –

Actually, that should work fine. I just made a sample sim with a model that had named range “Price”. In a text box I entered

Value is {{ Price }} or {{B2}} or {{ B2:B2 }}
and it displayed
Value is 500 or 500 or 500

all three worked.

Let us know if there’s a URL you’d like us to check out and we can offer suggestions.

WILL