#Unparseable Error When attempting to use IF function

Lota

Hello Everyone, I am trying to write an IF function to automatically change the value of a certain cell for certain conditions.

For some reason I keep getting the #Unparseable error when I type out this formula.

=IF((NETDAYS([Date Need By] 6, Today())) < 3, [At Risk], [In Progress])

I have attached a screenshot of the sheet.

Your help is greatly appreciated.

Thank you.

Brian W

I think you want to put At Risk and In Progress in quotes instead of brackets.

Paul Newcome

You also have an extra set of (). Try this...

 

=IF(NETDAYS([Date Need By] 6, Today()) < 3, "At Risk", "In Progress")

Lota

Thanks for the help, greatly appreciated.

Lota

Thanks for the help, greatly appreciated.