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.