If isblank today()

[kkrishna]

Greetings to Tech Gurus,

I'm seeking help in nesting a formula but ending up with an error. Please see below details for my formula nesting.

C3= % (this cell will have number up to 100 in %)
F3= Date (this cell will have date in MM/DD/YYYY format)
G3= formula (below is the formula which i'm trying nest)
=IF(ISBLANK(F3),"",IF(F3-TODAY()<=0,"Available","Available After "&F3-TODAY()&" days")

I know i'm doing crazy here with messing up with multiple formulas without a proper equation and that's why i'm here to seek your advise.

in fact i'm too expecting Cell C3 to be added before "Available After "&F3-TODAY()&" days" just like (=C3&" FTE Available After "&F3-TODAY()&" days")

your advises and guidance will greatly helpful.

Thank you.

 

[mole999]

maybe
=IF(C3="","",IF(F3-TODAY()<=0,"Available","Available After " & SUM(F3-TODAY()) & " days"))

 

[kkrishna]

@mole999, thanks for your response. Unfortunately it wasn't working.

 

[mole999]

works when tested, so what have you done in real time. Do you use a english language layout