comparing two ranges of cells if they're blank

[mirella]

Thanks to kpark91, I am using the below formula to tell me if two cells are both not blank (two cells both have data), there is a "conflict"

=IF(OR(V3 = "", X3 = ""), "ok", "CONFLICT")

I need to make it a bit more complicated now and ask it to tell me if there is any data in two ranges of cells, there is a conflict. In other words, if there is data in either cell T3, U3 or V3 AND there is data in either cell X3, Y3 or Z3, tell me it's a conflict. I tried the below formula but that didnt work. I tried parenthesis around the range and that didn't work.
=IF(OR(T3:V3 = "", X3:Z3 = ""), "ok", "CONFLICT")

Any ideas? Thanks!

 

[machopicho]

Insert with CTRL+ SHIFT + ENTER... not just ENTER.

 

[mirella]

Insert with CTRL+ SHIFT + ENTER... not just ENTER.

That made brackets appear around the formula and it did switch the output from "#VALUE" to "ok". However, it only gives me a "conflict" if every cell in AQ3 to AS3 has data. I need it to give me a "conflict" if any cell in that range has data.
{=IF(OR(AO3 = "", AQ3:AS3 = ""), "ok", "CONFLICT")}

Thoughts?

 

[machopicho]

=IF(ISERROR(IF(OR(AO3 = "", AQ3:AS3 = ""), "ok", "CONFLICT"))=TRUE,"",IF(OR(AO3 = "", AQ3:AS3 = ""), "ok", "CONFLICT"))

 

[mirella]

=IF(ISERROR(IF(OR(AO3 = "", AQ3:AS3 = ""), "ok", "CONFLICT"))=TRUE,"",IF(OR(AO3 = "", AQ3:AS3 = ""), "ok", "CONFLICT"))

Nope, that didn't do anything It's odd, it doesn't give an ok, conflict or error message. The cell just stays blank, even after hitting control, shift, enter.

This is a tough problem!

 

[machopicho]

My excel is in italian language and on my pc formula works well.
Check yuor formula error on your excel