Trevor --

You need to construct nested IF statements differently, with each one
usually set as the "if-false" part of the prior one. I can't figure out what
you're trying to accomplish specifically, but it should look something like
this:

=IF(TODAY()A13,"Overdue",IF(TODAY()C13,"CLOSED", "OPEN"))

HTH

"trevor" wrote:

Hi All

I am writing a formula to return 3 values, using 2 IF statement.

=IF(TODAY()A13,"OVERDUE","OPEN"),IF(TODAY()C13," CLOSED")
But for some reason it keeps on returning an error message #value!

Cell A13 & C13 contains dates, formmatted!
Do i need to unformat the dates to read better? ie: 38143 = 06/06/2008

Also I have two other cell which can determin the closed date, which you
enter the either a two figure number or another cell with a year date (ie:
2007-2008)

Thanks