Multiple If's and OR's
Try something like this:
With
A1 and A2 containing color names
A3: =SUM((A1&A2={"RedBlue","GreenOrange","PurpleYellow "})*{10,20,30})
Is that something you can work with?
***********
Regards,
Ron
XL2002, WinXP
"Shelly" wrote:
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!!
|