IF OR and ELSE

[Blake 7]

Hi Guys - i/m under pressure at work and beginning to melt under the strain!

I have a spreadsheet which has 30701 Rows! dont ask!

I need a formula in column S2:S30701 which says:

If cell T2 = "unknown" and cell O2 = 3 then "unknown withdrew"

AND

if cell T2 = "unknown" and O2 = 1 or 2 then "unknown complete"

otherwise = T2

am i gibbering??????

Thanks alot

[martindwilson]

=IF(AND(T2="unknown",OR(O2={1,2})),"unknown complete",IF(AND(T2="unknown",O2=3),"unknown withdrawn",T2))

[Blake 7]

Hiya Martin - thanks alot. One of those days where I doubt my own name!

they are making redundancies here! (more for less apparently) so ship scared to make a mistake!!!

Cheers