IF THEN FORMULA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

"(e-mail address removed)"
 
Can you please turn off the Caps-Lock key, and use mixed case?

Thanks

Bob

"(e-mail address removed)"
 
I'm totally lost here;
Your formula is in cell C1?
What is in cell a1 and b1?
Tks,
Jim
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF THEN FORMULA 5
if then 1
Auto Fill Help 1
IF statement with nested SUMPRODUCT? 3
Multiplying the number in one cell and providing the product in an 4
locate a column, sum specific columns to the right of that column 3
formula to display cell address 2
Excel formulas 2

Back
Top