ooops!

I missed a couple of quotes:

=IF(AND(A1="red",A2="blue"),10,IF(AND(A1="green",A 2="orange"),20,IF(AND(A1="purple",A2="yellow"),30, 0)))

Biff

"T. Valko" wrote in message
...
One way:

=IF(AND(A1="red",A2="blue"),10,IF(AND(A1="green",A 2="orange"),20,IF(AND(A1=purple",A2=yellow"),30,0) ))

You didn't say what you want if *none* of those conditions are met so the
formula will return 0.

Biff

"Shelly" wrote in message
...
Hello - I've searched, but cannot find what I'm looking for... I need to
do
this:

In the cell A3 the formula should say

If A1 = "red" and if A2 = "blue" enter 10 in A3, or
If A1 = "green" and if A2 = "orange" enter 20 in A3, or
If A1 = "purple" and if A2 = "yellow" enter 30 in A3.

And, I will need to replicate this down a column of 5 rows.

THANKS!!