Dear expert
i have aging formula to calculate with a or b depends upon condition of a and b column.
I have column in column a and b i want aging depends upon cell value below....
If a column is blank then take aging with b
if b column is blank then take agin with a
if a & b both column is blank result not found
if a & b column have date i want calculate aging with latest date.
Find the attachment
you may get understand@!!!!!!
Put this formula in C2 and copy down.
Formula:
Please Login or Register to view this content.
Last edited by AlphaFrog; 09-03-2013 at 04:34 AM.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Hello breadwinner,
And for Column D you could use: =IF(AND(A2="",B2=""),"Not Found",IF(A2 > B2,A2, B2))
provided you have Columns A & B correctly formatted, as I have done for you in the attached Workbook.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
DUDE
ITS WORKING PERFECTLY
=IF(COUNT(A2:B2)=0,"NOT FOUND",LOOKUP(TODAY()-MAX(A2:B2),{0,3,6,11,21,31},{"1-2","3-5","6-10","11-20","21-30",">30"})&" Days")
IF I ENTER THE FUTURE EITHER A OR B I WANT RESULT IN - MINUS IF A COULMN 02-09-2013 AND B 07-09-2013 RESULT -0-2 DAYS
CAN U MAKE CHANGES
Last edited by breadwinner; 09-03-2013 at 05:53 AM. Reason: EXPLANATION
Originally Posted by breadwinner
Formula:Please Login or Register to view this content.
Last edited by AlphaFrog; 09-03-2013 at 05:59 AM.
DUDE I WANT SAME RESULT LIKE IN AGING FORMAT -(0-2 Days)
example if A have 01-09-2013 B have 05-09-2013 so here B have greater than today date so formula has to take 05-09-2013 for aging result i want how many days range of aging from today date, result -(0-2 Days) or -3-5 Days or -6-10 Days or -11-20Days or -21-30 Days or >30 Days...if it A OR B cross today date RESULT in agint with minus
sorry for tro
YOU'RE WELCOME...DUDE
Formula:Please Login or Register to view this content.
Perfect It works 100% Dude You are Alpha for excel....Thanks alot
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks