I am trying to use the TODAY() function as a condition in an IFS() function. This is my equation: =IFS(TODAY()<20, P10, TODAY()>=20, P9) . Am I using properly, or is there a better solution?
I am trying to use the TODAY() function as a condition in an IFS() function. This is my equation: =IFS(TODAY()<20, P10, TODAY()>=20, P9) . Am I using properly, or is there a better solution?
Use: =IF(DAY(TODAY()) < 20, P10, P9) or =IF(TODAY()) < DATE(YEAR(TODAY()),MONTH(TODAY()),20), P10, P9)
Click the * to say thanks.
Thank you, I was letting my mind be to complicated.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks