Untitled.png
1.) I have this formula in "days outstanding" column =IF(ISBLANK(C2),"",IF(TODAY()<>C2,TODAY()-C2,1)). Now, if the receivables is already paid, how can I stop the updating the number of days outstanding in my aging of receivables.
2.) How can I put a text "Cancelled" that will never give me the answer "#VALUE!" in formula in my other aging column.
Thanks for the help.
It is difficult to solve a problem from a snapshot. To get better help please upload a sample sheet with your expected results.
In the meantime, I will try to give you some helpful hints, first you can change this part from =IF(ISBLANK(C2),"" to =IF(C2="",""
Next, wherever your "receivables" are located if you add that to the beginning part of your formula it will stop the formula at that point. So let's say that if the running balance in F9 and the number in O9 are equal then you want the formula to stop, then you could add this to the beginning =IF(F9=O9,"Cancelled",IF(C2="","",IF(TODAY()<>C2,TODAY()-C2,1)))
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Thank you for the awesome reply. I already applied your formula,sir.
Thanks!
Last edited by njgogobusia1988; 03-22-2016 at 01:58 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks