Afternoon all,
Can anyone help me with this - I've had a hunt around and can't find anything on this so I hope someone can help me.
I have a list of 10 conditions that could be entered into a cell (G210 in this case). What I need to do is to enter into cell AJ210 a formula that checks G210 and returns the result in AJ210, based on what it finds.....e.g:
If G210 = Condition 1, 2 or 3, 4, 5, enter into AJ210 result 1.
or...
If G210 = Condition 6, 7, or 8, enter into AJ210 result 2.
or...
If G210 = Condition 9, or 10, enter into AJ210 result 3.
(I then need to count the resultant conditions, but that's another story....)
I tried to use something along these lines:
=IF(C210="","",IF(OR(G210="Condition 1",G210="Condition 2"),"Result 1","Result 2"),IF(OR(G210="Condition 6",G210="Condition 7",G210="Condition 8"),"Result 3","Result 1"))
...but I get too many arguments error.
Can anyone set me on the correct path?
Many thanks.
Jeremy.
Can anyone help me with this - I've had a hunt around and can't find anything on this so I hope someone can help me.
I have a list of 10 conditions that could be entered into a cell (G210 in this case). What I need to do is to enter into cell AJ210 a formula that checks G210 and returns the result in AJ210, based on what it finds.....e.g:
If G210 = Condition 1, 2 or 3, 4, 5, enter into AJ210 result 1.
or...
If G210 = Condition 6, 7, or 8, enter into AJ210 result 2.
or...
If G210 = Condition 9, or 10, enter into AJ210 result 3.
(I then need to count the resultant conditions, but that's another story....)
I tried to use something along these lines:
=IF(C210="","",IF(OR(G210="Condition 1",G210="Condition 2"),"Result 1","Result 2"),IF(OR(G210="Condition 6",G210="Condition 7",G210="Condition 8"),"Result 3","Result 1"))
...but I get too many arguments error.
Can anyone set me on the correct path?
Many thanks.
Jeremy.