IF / AND formula help

[Hayley_A]

Can anyone suggest a formula that would work for the below:

Due Date	Date Paid	Company Paid?
​

I'm looking for 3 outputs for the 'Company Paid?' column - Pending, Overdue & Paid.
Pending - when 'date paid' is blank and todays date is <'Due date'
Overdue - when 'date paid' is blank and todays date is >'Due date'
Paid - when 'date paid' is not blank

I've got as far as:
=IF((AND(ISBLANK([@[Date Paid]]), [@[Due Date]]<TODAY())), "OVERDUE", "Pending")

but i'm stuck on how to then add in the 'Paid' element for when a date has been input into the 'Date Paid' column.

Any help would be appreciated!

 

[Toadstool]

Hi Hayley_A,

Does this work for you?

Hayley_A.xlsx
	A	B	C
1	Due Date	Date Paid	Company Paid?
2	1/1/2021		OVERDUE
3	2/2/2021	1/1/2021	Paid
4	9/9/2021		Pending
5	8/8/2021		OVERDUE
Sheet1

Cell Formulas
Range	Formula
C2:C5	C2	=IF([@[Date Paid]]<>"","Paid",IF(TODAY()<=[@[Due Date]],"Pending","OVERDUE"))

 

[Hayley_A]

=IF([@[Date Paid]]<>"","Paid",IF(TODAY()<=[@[Due Date]],"Pending","OVERDUE"))

This works like a dream, thank you so much!!

 

[Toadstool]

This works like a dream, thank you so much!!

You're welcome!
Thanks for the feedback.