u/Cold_Ad_6766

Hi there! As the title says, I've only done a few codes before, and I'm struggling with this one.

I'm trying to print "H" if all statements are true and leave it blank if any element in the statement isn't true. I need column L to have a value of 4 or 5, column N to use the phrase "I avoid it," and column AD to be blank. I'm using the fourth row as the testing ground. I have so far:

=IF(

or(

	L4 = "5", L4 = "4")

	\+(N4 = "I avoid it.")

	\+(ISBLANK(AD4))

"H", "")

I've also tried making BK return a value of 1 if L is 4 or 5 and 0 if it's anything else, and then doing =IF((BK4=1), but I haven't been able to parse it.

I'm not sure where I'm going wrong and any help would be super appreciated!!