how to write if condition to include more options

genetist

Board Regular
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>

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
How is your data laid out exactly?

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

Regards,
Genetist

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

Replies
1
Views
108
Replies
9
Views
151
Replies
10
Views
279
Replies
12
Views
269
Replies
1
Views
400

1,196,515
Messages
6,015,660
Members
441,913
Latest member
Lhayden_69

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back