Hello, I tried to add this last line IF('[EUCOM Revised SEMA Training Matrix 20220219.xlsx]Conditional '!$D5-TODAY()<1,"OVER",""
To a function that was working. Now it says I am getting an error for too many arguments.
Here is the new formala below. Please help.
=IF('[EUCOM Revised SEMA Training Matrix 20220219.xlsx]Conditional '!$D5="","",IF('[EUCOM Revised SEMA Training Matrix 20220219.xlsx]Conditional '!$D5="NA","", IF('[EUCOM Revised SEMA Training Matrix 20220219.xlsx]Conditional '!$D5-TODAY()<45, "<45","", IF('[EUCOM Revised SEMA Training Matrix 20220219.xlsx]Conditional '!$D5-TODAY()<1,"OVER",""))))
To a function that was working. Now it says I am getting an error for too many arguments.
Here is the new formala below. Please help.
=IF('[EUCOM Revised SEMA Training Matrix 20220219.xlsx]Conditional '!$D5="","",IF('[EUCOM Revised SEMA Training Matrix 20220219.xlsx]Conditional '!$D5="NA","", IF('[EUCOM Revised SEMA Training Matrix 20220219.xlsx]Conditional '!$D5-TODAY()<45, "<45","", IF('[EUCOM Revised SEMA Training Matrix 20220219.xlsx]Conditional '!$D5-TODAY()<1,"OVER",""))))