how to write if condition to include more options

[genetist]

Hi to all, i need help in solving my problem,
My data looks like this
i.d m1 m2 m3 m4 O1 O2 O3 O4
p1 aa gg -/- z/z mono poly poly poly
p2 aa aa tt cc

i written if condition like this in blank O1 cell =if (P1=P2,"mono","poly") and i got mono for m1 in O1 cell,poly in O2 cell,poly in O3 & O4 for m3 and m4 cell values, but i want to give mono for m3 and m4 values (-/-,z/z) in O3 and O4 columns. -/- and z/z are the type of missing values thats the reason i want to give them as mono.

my output looks like this

i.d	m1	m2	m3	m4	O1	O2	O3	O4
p1	aa	gg	-/-	z/z	mono	poly	mono	mono
p2	aa	aa	tt	cc

<TBODY>
</TBODY>

 

[Andrew Poulsom]

How is your data laid out exactly?

 

[genetist]

How is your data laid out exactly?

Thank you andrew for spending your time to help me.
before i am giving mono title for observations p1 and p2 if they contains same letter ex p1=gg and p2=gg but now i want to give mono tilte if any one of these p1 or p2 contains Z/Z or -/-. thats all i want

Thanks in advance,
Regards,
Genetist

 

[Andrew Poulsom]

What ranges do your data occupy? I'm confused by p1, p2 and m1, m2, m3 and m4.