Multiple If/And/Or Conditions in the Same Cell

[reberryjr]

I need to interrogate several conditions within the same cell. I've been able to create individual formulas to come up with the answers I expect, but when I try to concatenate those formulas into a single formula, I don't get the expected values. I'm not overly familiar with nesting If/And/or statements; but here are the 2 core formulas I'm trying to concatenate and a dummy table. Note that the word "spaces" is a placeholder, and in the formula it's actually 5 spacebar strokes.
'=IF(OR(AC2="!",AC2="3",AE2="3")*AND(AD2<>"",AD2<>" "),"Y","N")
'=IF(AND(OR(AC4<>"!",AC4<>"3",AE4<>"3")*AND(AD4<>"",AD4<>" ")),"Y","N")

AC	AD	AE	AL
!	Spaces	0	Y
3	Spaces	5	Y
0	Spaces	3	Y
0	12	4	Y
5	45678	2	Y
6	Null	9	N
4	Spaces	8	N
!	12345	5	N
3	56789	6	N
0	89511	3	N

 

[jasonb75]

See if this does what you need. Are you sure that you want "3" and not just 3 ? A number enclosed in double quotes is text, not a number, the 2 are not directly comparable. =IF("3"<>3 will return TRUE, =IF("3"=3 will return FALSE.

=IF(OR(AND(OR(AC2="!",AC2="3",AE2="3"),AD2<>"",AD2<>" "),AND(OR(AND(AC4<>"!",AC4<>"3"),AE4<>"3"),AD4<>"",AD4<>" ")),"Y","N")

One more point to note from your formulas, OR(AC4<>"!",AC4<>"3",AE4<>"3") having 2 <> criteria for the same cell with OR serves no purpose, one of them will always be TRUE.

 

[reberryjr]

Unfortunately the formula provided didn't work. Great point about the double OR. I decided to employ helper columns to get the result I need. Many thanks for the feedback!!!