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