Adding text when formula calculates blank

[Nick221_]

I have the below formula that is calculating the last blank value and pulling it into this new table. My question is it easily possible to add another part of this formula to insert the phrase "Not submitted" if the formula is pulling a blank value.

[Nick221_]

That worked! Thank you so much!

[olgad]

Please kudo and accept as a solution, thank you! 

[olgad · Accepted solution]

Hi, 
before your formula place If( your whole formula=blank(), "Not submitted", yourfromula)

or to make things cleaner use variable: 
Completed=
var vCompleted= your formula
If( vCompleted=blank(), "Not submitted", vCompleted)