can I make the word grading tractor show on my sheet but holds the value of
$80?

if so How can i do it?

This is just a guess, but of you had a drawing toolbar textbox named Word
Grading Tractor, this would work.

Sub ShowWordGradingTractor()
With ActiveSheet.Shapes("Word Grading Tractor")
.TextFrame.Characters.Text = "$80"
.Visible = True
End With
End Sub

Perhaps another attempt at describing what you want.

--
Regards,
Tom Ogilvy


"
.com wrote in message
...
can I make the word grading tractor show on my sheet but holds the value
of
$80?

if so How can i do it?

Elisa,

Am not sure what you are asking for.

I did enter "grading tractor" into a cell.
Than I went to insert name (with the cell still selected)
The dialong suggested that the name be: "grading_tractor"
In the refers to box I put : "=80"
(the quotes are mine and you shouldn't use them)

In another cell I put: "=grading_tractor"
and the cell showed the value 80

???

--
steveB

Remove "AYN" from email to respond
"
.com wrote in message
...
can I make the word grading tractor show on my sheet but holds the value
of
$80?

if so How can i do it?

Sub EFG()
Dim nme As Name
Set nme = ThisWorkbook.Names.Add(Name:="Grading_Factor", _
RefersTo:="=""$80""")
ActiveCell.Formula = "=Grading_Factor"

End Sub

or

Sub EFG()
Dim nme As Name
Set nme = ThisWorkbook.Names.Add(Name:="Grading_Factor", _
RefersTo:="=$80")
ActiveCell.Formula = "=Grading_Factor"
ActiveCell.Numberformat = "$#,###"

End Sub

--
Regards,
Tom Ogilvy



"STEVE BELL" wrote in message
news:fmV2f.14661$Tn5.11076@trnddc08...
Elisa,

Am not sure what you are asking for.

I did enter "grading tractor" into a cell.
Than I went to insert name (with the cell still selected)
The dialong suggested that the name be: "grading_tractor"
In the refers to box I put : "=80"
(the quotes are mine and you shouldn't use them)

In another cell I put: "=grading_tractor"
and the cell showed the value 80

???

--
steveB

Remove "AYN" from email to respond
"
.com wrote in message
...
can I make the word grading tractor show on my sheet but holds the value
of
$80?

if so How can i do it?

OK I GOT THAT PART THANK YOU......... =SUM(GRADING_TRACTOR*E3)

KEEP IN MIND THAT I ENTER GRADING TRACTOR IN CELL A1.
CELL E3 HAS THE NUMBER 8 AND CELL F3 HAS THE ABOVE FORMULA.

NOW IF I CHANGE CELL A1 FROM A GRADING TRACTOR TO LABOR WITH THE VALUE OF
($28) HOW CAN I MAKE MY FORMULA IN CALL F3 DISTINGUISH THAT WITH OUT HAVE TO
CHANGE THE FORMULA MANUALLY.

THANK YOU VERY MUCH

"STEVE BELL" wrote:

Elisa,

Am not sure what you are asking for.

I did enter "grading tractor" into a cell.
Than I went to insert name (with the cell still selected)
The dialong suggested that the name be: "grading_tractor"
In the refers to box I put : "=80"
(the quotes are mine and you shouldn't use them)

In another cell I put: "=grading_tractor"
and the cell showed the value 80

???

--
steveB

Remove "AYN" from email to respond
"
.com wrote in message
...
can I make the word grading tractor show on my sheet but holds the value
of
$80?

if so How can i do it?

Insert = Name = Define
Name: Grading_Tractor
RefersTo: =Sheet1!$A$1

Click the Add button.

--
Regards,
Tom Ogilvy

"
.com wrote in message
...
OK I GOT THAT PART THANK YOU......... =SUM(GRADING_TRACTOR*E3)

KEEP IN MIND THAT I ENTER GRADING TRACTOR IN CELL A1.
CELL E3 HAS THE NUMBER 8 AND CELL F3 HAS THE ABOVE FORMULA.

NOW IF I CHANGE CELL A1 FROM A GRADING TRACTOR TO LABOR WITH THE VALUE OF
($28) HOW CAN I MAKE MY FORMULA IN CALL F3 DISTINGUISH THAT WITH OUT HAVE
TO
CHANGE THE FORMULA MANUALLY.

THANK YOU VERY MUCH

"STEVE BELL" wrote:

Elisa,

Am not sure what you are asking for.

I did enter "grading tractor" into a cell.
Than I went to insert name (with the cell still selected)
The dialong suggested that the name be: "grading_tractor"
In the refers to box I put : "=80"
(the quotes are mine and you shouldn't use them)

In another cell I put: "=grading_tractor"
and the cell showed the value 80

???

--
steveB

Remove "AYN" from email to respond
"
.com wrote in message
...
can I make the word grading tractor show on my sheet but holds the
value
of
$80?

if so How can i do it?

i'm not good enough to write a function, but wouldn't a function do this

If Range("a1") = "grading_tractor" Then
icost = 80
Else
If Range("a1") = "labor" Then
icost = 28

then the formula in f3 could be = icost*whatever
--


Gary


"Tom Ogilvy" wrote in message
...
Insert = Name = Define
Name: Grading_Tractor
RefersTo: =Sheet1!$A$1

Click the Add button.

--
Regards,
Tom Ogilvy

"
.com wrote in message
...
OK I GOT THAT PART THANK YOU......... =SUM(GRADING_TRACTOR*E3)

KEEP IN MIND THAT I ENTER GRADING TRACTOR IN CELL A1.
CELL E3 HAS THE NUMBER 8 AND CELL F3 HAS THE ABOVE FORMULA.

NOW IF I CHANGE CELL A1 FROM A GRADING TRACTOR TO LABOR WITH THE VALUE OF
($28) HOW CAN I MAKE MY FORMULA IN CALL F3 DISTINGUISH THAT WITH OUT HAVE
TO
CHANGE THE FORMULA MANUALLY.

THANK YOU VERY MUCH

"STEVE BELL" wrote:

Elisa,

Am not sure what you are asking for.

I did enter "grading tractor" into a cell.
Than I went to insert name (with the cell still selected)
The dialong suggested that the name be: "grading_tractor"
In the refers to box I put : "=80"
(the quotes are mine and you shouldn't use them)

In another cell I put: "=grading_tractor"
and the cell showed the value 80

???

--
steveB

Remove "AYN" from email to respond
"
.com wrote in
message
...
can I make the word grading tractor show on my sheet but holds the
value
of
$80?

if so How can i do it?

Hi Gary

can you please lead me step by step in how and where to enter that function

thank you

"Gary Keramidas" wrote:

i'm not good enough to write a function, but wouldn't a function do this

If Range("a1") = "grading_tractor" Then
icost = 80
Else
If Range("a1") = "labor" Then
icost = 28

then the formula in f3 could be = icost*whatever
--


Gary


"Tom Ogilvy" wrote in message
...
Insert = Name = Define
Name: Grading_Tractor
RefersTo: =Sheet1!$A$1

Click the Add button.

--
Regards,
Tom Ogilvy

"
.com wrote in message
...
OK I GOT THAT PART THANK YOU......... =SUM(GRADING_TRACTOR*E3)

KEEP IN MIND THAT I ENTER GRADING TRACTOR IN CELL A1.
CELL E3 HAS THE NUMBER 8 AND CELL F3 HAS THE ABOVE FORMULA.

NOW IF I CHANGE CELL A1 FROM A GRADING TRACTOR TO LABOR WITH THE VALUE OF
($28) HOW CAN I MAKE MY FORMULA IN CALL F3 DISTINGUISH THAT WITH OUT HAVE
TO
CHANGE THE FORMULA MANUALLY.

THANK YOU VERY MUCH

"STEVE BELL" wrote:

Elisa,

Am not sure what you are asking for.

I did enter "grading tractor" into a cell.
Than I went to insert name (with the cell still selected)
The dialong suggested that the name be: "grading_tractor"
In the refers to box I put : "=80"
(the quotes are mine and you shouldn't use them)

In another cell I put: "=grading_tractor"
and the cell showed the value 80

???

--
steveB

Remove "AYN" from email to respond
"
.com wrote in
message
...
can I make the word grading tractor show on my sheet but holds the
value
of
$80?

if so How can i do it?

See latest thread by Elisa to see even more guesses.

--
Regards,
Tom Ogilvy

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
i'm not good enough to write a function, but wouldn't a function do this

If Range("a1") = "grading_tractor" Then
icost = 80
Else
If Range("a1") = "labor" Then
icost = 28

then the formula in f3 could be = icost*whatever
--


Gary


"Tom Ogilvy" wrote in message
...
Insert = Name = Define
Name: Grading_Tractor
RefersTo: =Sheet1!$A$1

Click the Add button.

--
Regards,
Tom Ogilvy

"
.com wrote in message
...
OK I GOT THAT PART THANK YOU......... =SUM(GRADING_TRACTOR*E3)

KEEP IN MIND THAT I ENTER GRADING TRACTOR IN CELL A1.
CELL E3 HAS THE NUMBER 8 AND CELL F3 HAS THE ABOVE FORMULA.

NOW IF I CHANGE CELL A1 FROM A GRADING TRACTOR TO LABOR WITH THE VALUE
OF
($28) HOW CAN I MAKE MY FORMULA IN CALL F3 DISTINGUISH THAT WITH OUT
HAVE
TO
CHANGE THE FORMULA MANUALLY.

THANK YOU VERY MUCH

"STEVE BELL" wrote:

Elisa,

Am not sure what you are asking for.

I did enter "grading tractor" into a cell.
Than I went to insert name (with the cell still selected)
The dialong suggested that the name be: "grading_tractor"
In the refers to box I put : "=80"
(the quotes are mine and you shouldn't use them)

In another cell I put: "=grading_tractor"
and the cell showed the value 80

???

--
steveB

Remove "AYN" from email to respond
"
.com wrote in
message
...
can I make the word grading tractor show on my sheet but holds the
value
of
$80?

if so How can i do it?