If Statement/Name Error

[erikakelsh]

I have a list of dates and want to be able to determine if they are valid or expired using an if statement.

I am using this formula: =IF(P18>TODAY,"VALID","EXP")

But the NAME error keeps showing up.

Any insight on this would be great. Thanks!

-Erika

 

[wigi]

You need to use

TODAY()

instead of

TODAY

Please have a look at the list of functions you can use. You will all details there.

 

[erikakelsh]

Great! Thanks, it worked perfectly.

Do you know what I am doing wrong when I insert this IF statement by chance?

=IF(P18="UNKNOWN","UNKNOWN",=if(P18>TODAY(),"VALID","EXP"))

Thanks again!

 

[njimack]

You have an equals sign preceding your 2nd IF statement.

 

[T. Valko]

Great! Thanks, it worked perfectly.

Do you know what I am doing wrong when I insert this IF statement by chance?

=IF(P18="UNKNOWN","UNKNOWN",=if(P18>TODAY(),"VALID","EXP"))

Thanks again!

Try it like this...

=IF(P18="UNKNOWN","UNKNOWN",IF(P18>TODAY(),"VALID","EXP"))

 

[erikakelsh]

Awesome. Thanks so much for the help! I appreciate it.

 

[T. Valko]

Awesome. Thanks so much for the help! I appreciate it.

You're welcome. Thanks for the feedback!

 

[prasadmoghe.pm]

Erika,
The parenthesis (brackets) are missing in the TODAY function.You need to change the word TODAY and make it a function TODAY(). It will work.

Hope that helps.

Regards,
Prasad

I have a list of dates and want to be able to determine if they are valid or expired using an if statement.

I am using this formula: =IF(P18>TODAY,"VALID","EXP")

But the NAME error keeps showing up.

Any insight on this would be great. Thanks!

-Erika