IF AND OR nested formula

[josephkoo21]

I am trying to do a formula that uses IF AND OR Functions. I thought this formula would work but it comes up with a #VALUE.

=IFERROR(IF(AND(MONTH(H158)=$AA$1,RIGHT(L158,8)="Outbound"),1,0),0)+X158, IF(K158="Upgrade Multi-Year Annual Access",0,1)

I want it to read if Month=AA1 and Right(L158,8) = Outbound then show a 1, or if K158= "Upgrade Multi-year annual access show a 0.

If the AND Function is showing 1 and if K158 does not = Upgrade Multi-year annual access it would show a 1.

[Dave2018]

is this 1 formula??

what is that space in the red? it looks like to separate formulas...

=IFERROR(IF(AND(MONTH(H158)=$AA$1,RIGHT(L158,8)="Outbound"),1,0),0)+X158, IF(K158="Upgrade Multi-Year Annual Access",0,1)

[josephkoo21]

Yes, I'm trying to make it 1 formula. Should I not have a space there? It still returns #VALUE, when i delete that space.

[Dave2018]

but the end of your formula is =IFERROR(IF(AND(MONTH(H158)=$AA$1,RIGHT(L158,8)="Outbound"),1,0),0)+X158

its like =SUM(1,2)+0, SUM(5,6)

the blue color being the formula and the red being out of place at the end, which doesnt make sense...

1)u understand what i mean? or should i explain better?

2) what are you accomplishing with IF(K158="Upgrade Multi-Year Annual Access",0,1)

-dave


EDIT: does this work?

=IFERROR(IF(AND(MONTH(H158)=$AA$1,RIGHT(L158,8)="Outbound"),1,IF(K158="Upgrade Multi-Year Annual Access",0,1)),0)+X158

[josephkoo21]

I see, so I would need to incorporate the last part into the first formula.

I'm trying to have it read that if K158="Upgrade Multi-Year annual access" show a 0. So basically, there are two assumptions being made. If Month=AA1 and Right(L158,8) = "Outbound" then show a 1, or if K158= "Upgrade Multi-year annual access show a 0. If K158 does not = "Upgrade Multi-year annual access" and the AND function = 1, then formula will show a 1.

Simplified
iF A=4 and B=2 return 1 but if C= 3, return 0.

[Dave2018]

does this work?

=IF(K158="Upgrade Multi-Year Annual Access",0,IFERROR(IF(AND(MONTH(H158)=$AA$1,RIGHT(L158,8)="Outbound"),1,0),0)+X158)

[josephkoo21]

Unfortunately, it does not work. It says "You've entered too few arguments for this function"

[Dave2018]

Unfortunately, it does not work. It says "You've entered too few arguments for this function"

.

here is a shorter version, and u can modify it with +X185 etc..

=IF(AND(K158<>"Upgrade Multi-Year Annual Access",MONTH(H158)=$AA$1,RIGHT(L158,8)="Outbound"),1,IF(K158="Upgrade Multi-Year Annual Access",0))

[josephkoo21]

It works! Thank you!!

[Dave2018]

my pleasure

(sometimes, its challenging to work on a formula that refrences A11 and H158, without it in front of you... . just a hint for future posts.)

all the best