Simple If formular

[esamuel]

Hi there,

I have an IF statement and I need to have another one in the same cell, which I'm not sure how to do.

If you look at the image I sketched out, I just need cell L11 to say DONE when cell O11 has the words PAID in them. Currently they are just counting the days from a particular date. That formula is show in the image and here ( =IF(G11="","",TODAY()-G11) ).

http://postimg.org/image/xirs7782l/

Could someone fill in the gaps please?

Cheers, E

 

[elmer007]

I can't see the image from the computer I'm on; however, I think the following formula may be what you're looking for: =IF(O11="PAID","DONE",IF(G11="","",TODAY()-G11))

 

[esamuel]

Ah perfect, thats it.

Thanks Elmer!