Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
IF THEN FORMULA
=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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
IF THEN FORMULA
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
IF THEN FORMULA
Answered in the original thread.
-- 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |