how to write nested if condition

[genetist]

Hi to all,
I need help in solving my problem, My data look like this

Parents sx1 sx2 sx3 sx4 sx5 sx1 sx2 sx3 sx4 sx5 P1 AA ZZ // AA GG P2 GG GG AA AA GG my IF result Parents sx1 sx2 sx3 sx4 sx5 sx1 sx2 sx3 sx4 sx5 P1 AA ZZ // AA GG P2 GG GG AA AA GG poly poly poly mono mono Expected Parents sx1 sx2 sx3 sx4 sx5 sx1 sx2 sx3 sx4 sx5 P1 AA ZZ // AA GG P2 GG GG AA AA GG poly mono mono mono mono <colgroup><col span="11"></colgroup><tbody> </tbody>

<tbody>
</tbody>

my if condition is like this =if(A2=A1,"mono","poly") but i want mono in the cells where there are ZZ and // this characters also. How can i write if condition formula to get my expected result?
help need in this issue
Thanks in advance,
Regards,
Genetist

 

[Jeffrey20]

Not a nested if, but it does what you want (If P1 or P2 is ZZ or //; or if P1=P2).

=IF(OR(A1="ZZ";A1="//";A2="ZZ";A2="//";A1=A2)=TRUE;"mono";"poly")

 

[kevatarvind]

try below

=IF(A1=A2,"mono",IF(OR(A1="ZZ",A1="//"),"mono",IF(OR(A2="ZZ",A2="//"),"mono","poly")))

 

[genetist]

Hi
ARAVIND and Jefrey20 thank you very much for your help and spending your valuable time to help me. your formula is working and i adjusted according to my requirement.
Thanks lot
Regards,
genetist