How do I Designating a number with letters?

[dgb82]

Winter Delta T = 82 Deg. F
Heating Design Degree Day = 6493 heating degree-days


In a work sheet, there are calculations that designate the letters dt or dd
as the number 82 or 6483.

EX:
Btu/h
=D9*E9*DT

Btu/h
352,469

Or just:

when you type =DT in a cell, the number 82 is put into that cell in the work
sheet.

I would much appreciate it if some one can help me understand how this is
done so I can replicate this in the future.

Thanks,

Don

 

[Sandy Mann]

Define the letters as Names: Insert > Name > Define and give them the values
=82 & =6493. You can then use them as you are wanting to.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Pete_UK]

Select a cell somewhere in your workbook (eg X1 and enter the value 82
in there). Then click on Insert | Name | Define and give that cell the
name DT.

Then in another cell enter the formula:

=DT

and 82 will appear there.

Hope this helps.

Pete

 

[John C]

Insert|Name|Define, for example, say your numbers 82 and 6493 are in column
E, under the aforementioned menu area, you might find:
Names in workbook: DT
Refers to: $E1
This means it will always refer to column E, but since the row is relative
(no dollar sign), it will vary by row. For example, on row 17, you have =DT.
It will populate whatever value is in cell E17.

 

[Bob I]

See "Define Name". Basically the cell containing 82 has been named dt
and the cell containing 6493 has been named dd.

 

[dgb82]

Thank you,

Don

Insert|Name|Define, for example, say your numbers 82 and 6493 are in column
E, under the aforementioned menu area, you might find:
Names in workbook: DT
Refers to: $E1
This means it will always refer to column E, but since the row is relative
(no dollar sign), it will vary by row. For example, on row 17, you have =DT.
It will populate whatever value is in cell E17.

 

[dgb82]

Thank you,

Don

Define the letters as Names: Insert > Name > Define and give them the values
=82 & =6493. You can then use them as you are wanting to.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[dgb82]

Thank you Pete, your response and answer was well written. As a result, I
was able to replicate similar formulas.

Thanks again,

Don

 

[Pete_UK]

You're welcome, Don - thanks for feeding back.

Pete