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
|