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

=((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

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

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

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