Thread: IF THEN FORMULA
View Single Post
  #1   Report Post  
 
Posts: n/a
Default 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