IF(OR Formula with 4 criteria and 2 outcomes

Try it like this:

=IF(OR(C4=W1,D4=W2,E4=W3,F4=W4),'Mil Pay'!A2,"")

Hope this helps.

Pete

Thank you for the reply Pete but for some reason when none of the weeks populate in Cells C4:F4 cell A1 still has the report name in it and is not blank. Any ideas?

Try this ...

=IF(OR(AND(C4<>"",C4=W1),AND(D4<>"",D4=W2),AND(E4<>"",E4=W3),AND(F4<>"",F4=W4)),'Mil Pay'!A2,"")

Thank you for the post but it seems that formula will not populate the report name in A1, it just leaves the field blank no matter what does or doesn't populate in C4:F4, I tried tweaking it but couldn't find an answer. Please let me know if anyone has another solution

Can you attach a sample workbook?

sample should be attached, there are multiple other sheets that interact with this one to populate the weeks based on the macros assigned to the button which are not included.

W1 and W2 etc. are text values, so you need to do it like this:

=IF(OR(C4="W1",D4="W2",E4="W3",F4="W4"),'Mil Pay'!A2,"")

Hope this helps.

Pete

Hi Psychic,

Not the prettiest formula, but this should work in b5.

Please Login or Register  to view this content.

dmg 2016 thank you! it works like a charm! thank you Pete and Phuocam for the help as well I really appreciate it!