Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
=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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
=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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
=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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
=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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|