## View Poll Results: IF AND OR Statement, not working need help

Voters
0. This poll is closed
• IF AND or OR function is not giving correct result, need help

0 0%
• IF Logical function

0 0%
Multiple Choice Poll.

# Thread: IF AND OR excel statement

1. ## IF AND OR excel statement

Dear Experts,

I am hoping to get help from this forum, see below my comment and the work book attached.
 If D5, E5, F5, G5, H5... = C,Z,"" give "Comp" if there is any other values other than or along with C,Z,"" in cell D5, E5, F5, G5, H5... then give "No". for example if any the cells contains O,I,C,Z,"" then give "No" here is my formula working which is not working. Please see formulas Col. P Q R in sheet 1 IF(OR(D5="C",E5="C",F5="C",G5="C",H5="C",I5="C",J5="C",K5="C"),IF(OR(D5="",E5="",F5="",G5="",H5="",I5="",J5="",K5=""),IF(OR(D5="z",E5="Z",F5="Z",G5="Z",H5="Z",I5="Z",J5="Z",K5="Z"),"Complete","No"))) Thank you folks.IF OR AND Formula fix.xlsx

2. You are using the OR function so this is conradictory:

If D5, E5, F5, G5, H5... = C,Z,"" give "Comp"
if there is any other values other than or along with C,Z,"" in cell D5, E5, F5, G5, H5... then give "No". for example if any the cells contains O,I,C,Z,"" then give "No"
Please attach the workbook again, but this time fill column P manually with the results you want.

You are using the OR

3. Why did you create a poll?

Column P is manually filled.

Thank you for help

6. Originally Posted by Pecoflyer

Thank you.

7. No, I did not ask you to start a poll!

I asked you to add manually entered expected results to your workbook and then attach it again here.

I have closed the poll.

8. I not understanding about the poll, what is this. Is it different to thread I have created?

9. Look at the top of the thread - you must have added it when you started the thread.

No matter - just forget it now. I will look at your attachment tomorrow.

10. Originally Posted by AliGW
Look at the top of the thread - you must have added it when you started the thread.

No matter - just forget it now. I will look at your attachment tomorrow.
Thank you AliGW.

Page 1 of 4 1 2 3 ... Last