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!
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!