I am trying to return results if a date is less than, greater than or neither. My formula looks like this and keeps returning the #NAME? error:
=IFS(F8<$A$5,"PAST",F8>$A$5,"FUTURE",TRUE,"CURRENT")
A5 is today's date (=TODAY())
Thanks for any help.
Not sure what the problem is. Your formula works fine on my machine. It looks like this here:
I was thinking maybe you are in a region that uses , as the decimal separator, in which case you need to use ; instead of , in the formula, but I think that would give you a different kind of error.
SG
I need help with an IFS statement
