Thread: IF THEN FORMULA
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Mike Fogleman Mike Fogleman is offline
external usenet poster
 
Posts: 1,092
Default 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