Multi dependent formulas

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

Guest

I need a way to make formulas dependent on two conditions.

example:. C6 is the word Dust
D5 is the number 9
this would make F32 $9.50

I want to put rates in to come up when the word and number equal a rate. I
have around 20 different ones.
 
Thanks, now can I add more than one formula to the last cell? For instance if
the 9 is an 11 than it will equal 7.5 instead of 9.5?
 
Right and also

"Dust"
"NoDust"

Leslie said:
Thanks, now can I add more than one formula to the last cell? For instance if
the 9 is an 11 than it will equal 7.5 instead of 9.5?
Click to expand...
 
=IF(AND(C6="NoDust",D5=9),9.5,0)
=IF(AND(C6="LittleDust",D5=9),9.5,0)
=IF(AND(C6="AlotofDust",D5=9),9.5,0)
 
Hi Leslie

If you are going to have 20 rates, then you will be better off with a
Table. The table can exist on another sheet if required.
Starting with a new sheet, enter in
A2 Dust
A3 Grit
A4 Something else

In
B1 5
C1 7
D1 9
In
B2 $5.00
C2 $7.50
D3 $9.50

Complete the matrix with whatever are the appropriate numbers for the
different cases that you have.
In cell F32 of your Sheet1 enter
=INDEX(Sheet2!$A$1:$D4,MATCH(C6,Sheet2!$A$1:$A$4,0),
MATCH(D5,Sheet2!$A$1:$D$1,0))

Amend the ranges to suit the size of the Table you create
 
Back
Top