Please help very urgent ageing by if condiction

P

pol

I have three column in my excel sheet

1. Month
2. year
3. Amount
4. Period

In period column, I want to show
1. if the month is current month it should be shown as ' Curnet'
2. If the previous month it should be shown as '30'
3 if before previous month it should be 60
4 otherwise '120'

Please help
 
S

Stefi

Try this:
=CHOOSE(DATEDIF(DATE(B2,A2,1),TODAY(),"m")+1,"current","30","60","120")

--
Regards!
Stefi



„pol†ezt írta:
 
B

Bernard Liengme

Let's say the first row has labels, so A2 holds the first data value for
month
in D2 use
=IF(MONTH(TODAY())=A3,"Current",IF(MONTH(TODAY())-A3=1,30,IF(MONTH(TODAY())-A3=2,60,120)))
This seems to do what you want but be warned: if month is > current month
you get 120
Please give more exact info on what is really needed
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Please help very urgent to give ageing report 4
Need some PWA help 0
Countifs or a pivot 1
Remove Identical words 0
Section and Page numbering 0
To find due days of debtors 2
Cumulative formula for word table 0
Linking Child Timelines to Multiple Parents 0

Top