IF THEN FORMULA

[Guest]

=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

 

[Bernie Deitrick]

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,E12,2,False)*E3

HTH,
Bernie
MS Excel MVP

"(e-mail address removed)"

 

[Tom Ogilvy]

Answered in the original thread.

 

[Mike Fogleman]

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
"(e-mail address removed)"

 

[Guest]

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"

 

[Tom Ogilvy]

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


With Grading Tractor in A1 I get 650

With Labor in A1 I get 224

--
Regards,
Tom Ogilvy


"(e-mail address removed)"