Nested Function, Too many arguments error

[jdub11]

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",""))))

 

[Peter_SSs]

Does this adjustment work for you?

=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",""))))

If it does, then you might also try this shorter version

=LET(v,'[EUCOM Revised SEMA Training Matrix 20220219.xlsx]Conditional '!$D5,IF(v="","",IF(v="NA","", IF(v-TODAY()<45, "<45", IF(v-TODAY()<1,"OVER","")))))

 

[Peter_SSs]

This question appears to be a duplicate to: Nested statement help

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread if my suggestion here is not what you want.