IF THEN FORMULA
 

=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

IF THEN FORMULA
 

It depends on how your names are defined. Perhaps, use the formula

=A1*E3

Or, if you have a table of values like this in, say, D1:E2

GRADING TRACTOR 100
LABOR 28

you could use something like

=VLOOKUP(A1,E1:D2,2,False)*E3

HTH,
Bernie
MS Excel MVP

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

IF THEN FORMULA
 

Answered in the original thread.

--
Regards,
Tom Ogilvy

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

IF THEN FORMULA
 

Is there a number associated with Grading_Tractor in A1? If so, what is that
association? Normally you would just refer to the cell itself in a formula,
and when the cell contents change, the formula re-calculates the new value.
In cell F3: =A1*E3
If E3 = 8 and A1=$28 then F3 will display 224

What does typing Grading_Tractor in A1, produce in F3?

Mike F
"
.com wrote in message
...
=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

IF THEN FORMULA
 

HI MIKE

SEE MY SPREAD SHEET SHOWS THE WORD "GRADING TRACTOR' BUT HOLDS THE VALUE OF
$80.
I entered "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"




"Mike Fogleman" wrote:

Is there a number associated with Grading_Tractor in A1? If so, what is that
association? Normally you would just refer to the cell itself in a formula,
and when the cell contents change, the formula re-calculates the new value.
In cell F3: =A1*E3
If E3 = 8 and A1=$28 then F3 will display 224

What does typing Grading_Tractor in A1, produce in F3?

Mike F
"
.com wrote in message
...
=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

IF THEN FORMULA
 

=SUM(Indirect(Substitute(A1," ","_"))*E3)


With Grading Tractor in A1 I get 650

With Labor in A1 I get 224

--
Regards,
Tom Ogilvy


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