Multi dependent formulas
 

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.

Multi dependent formulas
 

try this

=IF(AND(C6="Dust",D5=9),9.5,"")
"Leslie" wrote:

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.

Multi dependent formulas
 

or this
=IF(AND(C6="Dust",D5=9),9.5,0)

"Leslie" wrote:

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.

Multi dependent formulas
 

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?
--
Leslie


"Mike" wrote:

or this
=IF(AND(C6="Dust",D5=9),9.5,0)

"Leslie" wrote:

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.

Multi dependent formulas
 

Right and also

"Dust"
"NoDust"

"Leslie" wrote:

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?
--
Leslie


"Mike" wrote:

or this
=IF(AND(C6="Dust",D5=9),9.5,0)

"Leslie" wrote:

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.

Multi dependent formulas
 

huh?
I 'm sorry, I think I am excel challenged....
--
Leslie


"Mike" wrote:

Right and also

"Dust"
"NoDust"

"Leslie" wrote:

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?
--
Leslie


"Mike" wrote:

or this
=IF(AND(C6="Dust",D5=9),9.5,0)

"Leslie" wrote:

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.

Multi dependent formulas
 

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


"Leslie" wrote:

huh?
I 'm sorry, I think I am excel challenged....
--
Leslie


"Mike" wrote:

Right and also

"Dust"
"NoDust"

"Leslie" wrote:

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?
--
Leslie


"Mike" wrote:

or this
=IF(AND(C6="Dust",D5=9),9.5,0)

"Leslie" wrote:

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.

Multi dependent formulas
 

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
--
Regards

Roger Govier


"Leslie" wrote in message
...
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.