Need some help with an IF statement

[superkopite]

Hi Guys and Gals,

I have the statement =IF(O$2=$C3,1,)

and I need to amend it slighty. At the moment the highlighted cell will display a 1 if the value of o2 is equal to c3. What i want to do is that add another condition, so if o2=C4 AND C4 is equal to green then 1,if it is equal to Amber then 2, and 3 if it is equal to Red.

I am sure I know how to do this but think I have just confused myself, lol

Many Thanks

James

 

[superkopite]

I have tried

=IF(and(G$2=$C3, e3="green"),1,if(and(G$2=$C3, e3="Amber"),2,if(and(G$2=$C3, E3="red",3,0)

But I am missing the ))) and cannot work out where to put them

any ideas??

Thanks

 

[James006]

Hi,

Just at the end of your formula ...

 

[superkopite]

Thanks James,

I tried that but I get the "the forumla that you typed contains an error" message

 

[Weazel]

looks like you're missing a parenthesis after the 3rd AND

=IF(AND(G$2=$C3, E3="green"),1,IF(AND(G$2=$C3, E3="Amber"),2,IF(AND(G$2=$C3, E3="red"),3,0)))

 

[superkopite]

Thanks Weazel!!

That worked a treat!!!