How do I Designating a number with letters?
 

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

How do I Designating a number with letters?
 

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


Replace @mailinator.com with @tiscali.co.uk


"dgb82" wrote in message
...
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

How do I Designating a number with letters?
 

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

On Aug 6, 5:36*pm, dgb82 wrote:
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

How do I Designating a number with letters?
 

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.




--
John C


"dgb82" wrote:

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

How do I Designating a number with letters?
 

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

dgb82 wrote:

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

How do I Designating a number with letters?
 

Thank you,

Don

"John C" wrote:

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.




--
John C


"dgb82" wrote:

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

How do I Designating a number with letters?
 

Thank you,

Don

"Sandy Mann" wrote:

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


Replace @mailinator.com with @tiscali.co.uk


"dgb82" wrote in message
...
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

How do I Designating a number with letters?
 

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" wrote:

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

On Aug 6, 5:36 pm, dgb82 wrote:
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

How do I Designating a number with letters?
 

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

Pete

On Aug 6, 6:01*pm, dgb82 wrote:
Thank you Pete, your response and answer was well written. * As a result, *I
was able to replicate similar formulas.

Thanks again,

Don