=IF((TODAY()-B8)>30, "Overdue", "Current"),

[Kev]

I have used this formula to set up an invoice tracker.. My question is how
do I make the formula know when an invoice has been paid.

 

[Dave Peterson]

Use an extra column in that same row?

=if(x8="paid","",yourformula)

 

[Kev]

Thanks Dave
I only have very limited knowledge of formulas.... where you said
",yourformula) what do I put in there

 

[Dave Peterson]

You would put your formula--that thing from the subject line:

=if(x8="paid","",IF((TODAY()-B8)>30, "Overdue", "Current"))