View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shelly Shelly is offline
external usenet poster
 
Posts: 84
Default Multiple If's and OR's

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