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

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.

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

Use an extra column in that same row?

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


Kev wrote:

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

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

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

"Dave Peterson" wrote:

Use an extra column in that same row?

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


Kev wrote:

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

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

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

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



Kev wrote:

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

"Dave Peterson" wrote:

Use an extra column in that same row?

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


Kev wrote:

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


--

Dave Peterson