How do I Designating a number with letters?

  • Thread starter Thread starter dgb82
  • Start date Start date
D

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
 
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
 
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
 
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.
 
See "Define Name". Basically the cell containing 82 has been named dt
and the cell containing 6493 has been named dd.
 
Thank you,

Don

John C said:
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.
Click to expand...
 
Thank you,

Don

Sandy Mann said:
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
Click to expand...
 
Thank you Pete, your response and answer was well written. As a result, I
was able to replicate similar formulas.

Thanks again,

Don
 
Back
Top