Nested IF AND Excel Formula

[lashears]

Hi everyone,

need some urgent help.

I have a nested excel formula that keeps giving me the error that I'm missing a parenthesis, but when I fix what I believe is missing then it throws the whole formula into error.

Basically my nested IF)AND) nested formula is as follows:



=IF(Y4<>"Yes",0,if(S4<DATEVALUE("1/31/2021"),210,If(and(S4>=DATEVALUE("2/1/2021"),S4<=DATEVALUE("2/28/2021"),175,If(and(S4>=DATEVALUE("3/1/2021"),S4<=DATEVALUE("3/31/2021"),140,If(and(S4>=DATEVALUE("4/1/2021"),S4<=DATEVALUE("4/30/2021"),105,If(and(S4>=DATEVALUE("5/1/2021"),S4<=DATEVALUE("5/31/2021"),70,If(and(S4>=DATEVALUE("6/2/2021"),S4<=DATEVALUE("6/11/2021"),35)





can anyone tell me why I keep receive the "missing parenthesis" error?



thanks for your help!

 

[lashears]

I wrote Both of those formulas, in Post #4 and Post #12.

So you're saying Any date that is prior to 2021 gets 210, Not limited to 9/8/2020 to 12/31/2020, correct? Then:

=IFERROR(IF(Y4<>"Yes",0,IF(YEAR(S4)<2021,210,IF(AND(MONTH(S4)=6,DAY(S4)>=2,DAY(S4)<=11),35,CHOOSE(MONTH(S4),210,175,140,105,70)))),"")

I gotcha, thank you so much for this, you’re awesome?