Home |
Search |
Today's Posts |
#1
|
|||
|
|||
IF THEN FORMULA
IF I HAVE THE OPTION TO PUT ANY OF THE FOLLOWING NAME IN CELL A1
TRACTOR ( REFERS TO $80) BOBCAT( REFERS TO $50) LABOR (REFERS TO $28) AND I HAVE THE FORMULA =SUM(A1*B2) IN CELL C1 HOW CAN I REWRITE THIS FROMULA TO DISTINGUISH BETWEEN TRACTOR, BOBCAT AND LABOR? PLEASE HELP ME |
#2
|
|||
|
|||
=((A1="TRACTOR")*80+(A1="BOBCAT")*50+(A1="LABOR")* 28)*B1
-- HTH Bob Phillips " .com wrote in message ... IF I HAVE THE OPTION TO PUT ANY OF THE FOLLOWING NAME IN CELL A1 TRACTOR ( REFERS TO $80) BOBCAT( REFERS TO $50) LABOR (REFERS TO $28) AND I HAVE THE FORMULA =SUM(A1*B2) IN CELL C1 HOW CAN I REWRITE THIS FROMULA TO DISTINGUISH BETWEEN TRACTOR, BOBCAT AND LABOR? PLEASE HELP ME |
#3
|
|||
|
|||
THANK YOU BOB PHILLIPS......
THAT WAS WHAT I WAS LOOKING FOR!!!!!!!!!! "Bob Phillips" wrote: =((A1="TRACTOR")*80+(A1="BOBCAT")*50+(A1="LABOR")* 28)*B1 -- HTH Bob Phillips " .com wrote in message ... IF I HAVE THE OPTION TO PUT ANY OF THE FOLLOWING NAME IN CELL A1 TRACTOR ( REFERS TO $80) BOBCAT( REFERS TO $50) LABOR (REFERS TO $28) AND I HAVE THE FORMULA =SUM(A1*B2) IN CELL C1 HOW CAN I REWRITE THIS FROMULA TO DISTINGUISH BETWEEN TRACTOR, BOBCAT AND LABOR? PLEASE HELP ME |
#4
|
|||
|
|||
Can you please turn off the Caps-Lock key, and use mixed case?
Thanks Bob " .com wrote in message ... THANK YOU BOB PHILLIPS...... THAT WAS WHAT I WAS LOOKING FOR!!!!!!!!!! "Bob Phillips" wrote: =((A1="TRACTOR")*80+(A1="BOBCAT")*50+(A1="LABOR")* 28)*B1 -- HTH Bob Phillips " .com wrote in message ... IF I HAVE THE OPTION TO PUT ANY OF THE FOLLOWING NAME IN CELL A1 TRACTOR ( REFERS TO $80) BOBCAT( REFERS TO $50) LABOR (REFERS TO $28) AND I HAVE THE FORMULA =SUM(A1*B2) IN CELL C1 HOW CAN I REWRITE THIS FROMULA TO DISTINGUISH BETWEEN TRACTOR, BOBCAT AND LABOR? PLEASE HELP ME |
#5
|
|||
|
|||
I'm totally lost here;
Your formula is in cell C1? What is in cell a1 and b1? Tks, Jim "Bob Phillips" wrote in message ... =((A1="TRACTOR")*80+(A1="BOBCAT")*50+(A1="LABOR")* 28)*B1 -- HTH Bob Phillips " .com wrote in message ... IF I HAVE THE OPTION TO PUT ANY OF THE FOLLOWING NAME IN CELL A1 TRACTOR ( REFERS TO $80) BOBCAT( REFERS TO $50) LABOR (REFERS TO $28) AND I HAVE THE FORMULA =SUM(A1*B2) IN CELL C1 HOW CAN I REWRITE THIS FROMULA TO DISTINGUISH BETWEEN TRACTOR, BOBCAT AND LABOR? PLEASE HELP ME |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula? | Excel Worksheet Functions | |||
writing a formula for a colored value | New Users to Excel | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |