# Does Sharepoint allow IFS formula

I tested this on excel but can not translated to Sharepoint. I am trying to test for example if Column C has date that is greater than the one in column D = Submitted on time, if column C's date is less than the one in Column D than item was submitted late, but in some cases column D will be blank I want it to return Pending.

``````=IF(D5="","Pending Submission",IFS(C5>D5,"Submitted on time",C5<D5,"Late"))
``````
• This is the complete formulate I am using in Excel =IF(D5="","Pending Submission",IFS(C5>D5,"Submitted on time",C5<D5,"Late")) – Luis Jan 22 at 17:53

No, the `IF` function is supported in SharePoint formulas, but the `IFS` is not. But you can create a deeply nested `IF` condition where another `IF` function is used the third parameter (the "else" condition), so using the formula you presented you can achieve the same with:
`=IF([SubmissionDate]="","Pending Submission",IF([DeadlineDate]>[SubmissionDate],"Submitted on time",IF([DeadlineDate]<[SubmissionDate],"Late")))`
{"ft_lang_label":"__label__en","ft_lang_prob":0.952517,"math_prob":0.78799343,"size":403,"snap":"2020-34-2020-40","text_gpt3_token_len":100,"char_repetition_ratio":0.13533835,"word_repetition_ratio":0.0,"special_character_ratio":0.25558314,"punctuation_ratio":0.101123594,"nsfw_num_words":0,"has_unicode_error":false,"math_prob_llama3":0.96860737,"pos_list":[0],"im_url_duplicate_count":[null],"WARC_HEADER":"{\"WARC-Type\":\"response\",\"WARC-Date\":\"2020-08-04T12:33:45Z\",\"WARC-Record-ID\":\"<urn:uuid:49f3a748-7dd2-4191-ac5d-7067e950183a>\",\"Content-Length\":\"145926\",\"Content-Type\":\"application/http; msgtype=response\",\"WARC-Warcinfo-ID\":\"<urn:uuid:e4c76ea6-1277-4243-aec5-e703319bff5c>\",\"WARC-Concurrent-To\":\"<urn:uuid:9b040c6d-7e60-4807-af6f-9368f5a13eef>\",\"WARC-IP-Address\":\"151.101.129.69\",\"WARC-Target-URI\":\"https://sharepoint.stackexchange.com/questions/275047/does-sharepoint-allow-ifs-formula\",\"WARC-Payload-Digest\":\"sha1:CTAKZFM33TPITND56Y3TZ2GW5BSTGZHN\",\"WARC-Block-Digest\":\"sha1:7AALKDIJAOWDCC4TOFQA4PBVWHNT6ZD3\",\"WARC-Identified-Payload-Type\":\"text/html\",\"warc_filename\":\"/cc_download/warc_2020/CC-MAIN-2020-34/CC-MAIN-2020-34_segments_1596439735867.93_warc_CC-MAIN-20200804102630-20200804132630-00055.warc.gz\"}"}