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
|