software

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.

Use an extra column in that same row?

=if(x8=quot;paidquot;,quot;quot;,yourformula)Kev wrote:
gt;
gt; I have used this formula to set up an invoice tracker.. My question is how
gt; do I make the formula know when an invoice has been paid.

--

Dave Peterson

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

quot;Dave Petersonquot; wrote:

gt; Use an extra column in that same row?
gt;
gt; =if(x8=quot;paidquot;,quot;quot;,yourformula)
gt;
gt;
gt; Kev wrote:
gt; gt;
gt; gt; I have used this formula to set up an invoice tracker.. My question is how
gt; gt; do I make the formula know when an invoice has been paid.
gt;
gt; --
gt;
gt; Dave Peterson
gt;

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

=if(x8=quot;paidquot;,quot;quot;,IF((TODAY()-B8)gt;30, quot;Overduequot;, quot;Currentquot;))
Kev wrote:
gt;
gt; Thanks Dave
gt; I only have very limited knowledge of formulas.... where you said
gt; quot;,yourformula) what do I put in there
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; Use an extra column in that same row?
gt; gt;
gt; gt; =if(x8=quot;paidquot;,quot;quot;,yourformula)
gt; gt;
gt; gt;
gt; gt; Kev wrote:
gt; gt; gt;
gt; gt; gt; I have used this formula to set up an invoice tracker.. My question is how
gt; gt; gt; do I make the formula know when an invoice has been paid.
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson