how can i cover all this in an If statament

[Imran Azam]

<code>How Can I write an if statement to cover all the below rules?</code>
<code>If A1 = “yes” and B2 = "fast" then “ok”</code>
<code>but if C2 = “yes” and D2 = "pen" then “bright”</code>
<code>but if E2 = “yes” and F2 = yes then “light”</code>
<code>if G2 = “yes” and E2 = No and H2= "below" then“slow”</code>

or do I need a case statement?

 

[wideboydixon]

What the priority order? What do you expect here:

Book1
	A	B	C	D	E	F	G	H	I
1	yes
2		fast	yes	pen	yes	yes	yes	no	below
Sheet1

WBD

 

[snjpverma]

What will be the outcome if none of the criterias meet?

 

[Imran Azam]

Hi there will only be on occurrence at a time for for example

A B C D E
yes fast false false false ok
false false yes pen false bright

<tbody>
</tbody>

 

[Imran Azam]

What will be the outcome if none of the criterias meet?

leave it blank

 

[wideboydixon]

Book1
	A	B	C	D	E	F	G	H	I
2	yes	fast	no	pencil	no	no	no	above	ok
3	no	slow	yes	pen	no	no	no	above	bright
4	no	slow	no	pencil	yes	yes	no	above	light
5	no	slow	no	pencil	no	no	yes	below	slow
6	no	slow	no	pencil	no	no	no	above	???
Sheet1

Cell Formulas
Range	Formula
I2	=IF(AND(A2="yes",B2="fast"),"ok",IF(AND(C2="yes",D2="pen"),"bright",IF(AND(E2="yes",F2="yes"),"light",IF(AND(G2="yes",E2="no",H2="below"),"slow","???"))))

WBD

 

[Imran Azam]

thank you for your help guys