IF CONDITION ON DATE

Closed
anlene - Apr 25, 2010 at 01:44 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 25, 2010 at 07:41 PM
I am preparing Aging report in which paybles are on 30, 60 ,90 and 120 days. When using the IF condition for all the days . at the end of 120 days it will show in all the coloumn 30,60,90 and 120 as well. When it is 30 days all the 60,90 & 120 are empty this is ok. But what I need is a conditional formula if it is 90 days it should show in 90 days colomn and 30 & 60 days colomn should be empty.Like wise if the data is in 120 days all the rest 30,60 & 90 should be empty.

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Apr 25, 2010 at 07:41 PM
Could you please upload a sample file on some shared site like https://authentification.site and post back here the link to allow better understanding of how it is now and how you foresee. Please have couple of rows of data to show your issue.
0