close

I'm trying to create a formula and I need some help please.

In E3 I have a date, and in H3 I have the formula =E3-TODAY() to formulate
how many days until the date in E3 from today. However I want the formula in
H3 to return quot;Paidquot; if there is any text in G3. How would I write this
formula?

Thanks in advance.

=IF(ISTEXT(G3),quot;Paidquot;,E3-TODAY())

Vaya con Dios,
Chuck, CABGx3
quot;Rachel Kochquot; wrote:

gt; I'm trying to create a formula and I need some help please.
gt;
gt; In E3 I have a date, and in H3 I have the formula =E3-TODAY() to formulate
gt; how many days until the date in E3 from today. However I want the formula in
gt; H3 to return quot;Paidquot; if there is any text in G3. How would I write this
gt; formula?
gt;
gt; Thanks in advance.

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()