View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
pol pol is offline
external usenet poster
 
Posts: 129
Default 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