Which formula to use? IF?

[kaixin]

Hello,

I have a question here. I am trying to create formula to include 3 criterias.
Col A = Due Date (Range name: DueDate)
Col B = Status (Range name:Status)
Col C = Date of payment (Range name: PaymentDate)

My aim is to change the status from Due for payment / Outstanding to Paid if some dates have been included in Column C

Currently I only managed to change the Status to Due for payment or outstanding by using IF formula in Col B =IF(TODAY()>DueDate,"Due for payment","Outstanding")

Can anyone help me to incorporate the third criteria into the formula such that if Payment date is not blank, meaning PAID, the paid status is reflected under col B, if it's not paid (blank in Payment Date), it will still reflect due for payment if today date is greater than due date, and outstanding if the today date is smaller than the due date.

Thank you.

[dilipandey]

Hi kaixin,

Welcome to the forum.

suggest you to upload a sample workbook. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[dredwolf]

Try :

Please Login or Register  to view this content.

Hope this helps

[dilipandey]

Good try dredwolf.. and I like your signature statement

Regards,
DILIPandey

<click on below 'star' if this helps>