Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please help very urgent ageing by if condiction
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please help very urgent ageing by if condiction
Try this:
=CHOOSE(DATEDIF(DATE(B2,A2,1),TODAY(),"m")+1,"curr ent","30","60","120") -- Regards! Stefi €˛pol€¯ ezt Ć*rta: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please help very urgent ageing by if condiction
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 -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "pol" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ageing dates | Excel Worksheet Functions | |||
Pls help to find number of days for ageing report | Excel Discussion (Misc queries) | |||
Problem Ageing a Report | Excel Discussion (Misc queries) | |||
Formula for ageing debt | Excel Discussion (Misc queries) | |||
Help Please- How to offset Date to correct column for Ageing | Excel Discussion (Misc queries) |