Excel "If Then" Formula
Solved/Closed
jessica2991
Posts
4
Registration date
Thursday July 17, 2014
Status
Member
Last seen
July 30, 2014
-
Jul 17, 2014 at 03:50 PM
jessica2991 Posts 4 Registration date Thursday July 17, 2014 Status Member Last seen July 30, 2014 - Jul 30, 2014 at 01:34 PM
jessica2991 Posts 4 Registration date Thursday July 17, 2014 Status Member Last seen July 30, 2014 - Jul 30, 2014 at 01:34 PM
Related:
- Excel "If Then" Formula
- Excel grade formula - Guide
- Number to words in excel formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel mod apk for pc - Download - Spreadsheets
5 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jul 17, 2014 at 04:01 PM
Jul 17, 2014 at 04:01 PM
jessica2991, Good afternoon.
It sounds a little confuse.
Do you want this comparison to wich date?
Do you want one answer for each cell?
Please, tell us more details about your lay-out.
It sounds a little confuse.
Do you want this comparison to wich date?
Do you want one answer for each cell?
Please, tell us more details about your lay-out.
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jul 21, 2014 at 12:28 PM
Jul 21, 2014 at 12:28 PM
jessica2991, Good afternoon.
I did an example for you.
http://speedy.sh/yrJdZ/21-07-2014-en-kioskea-Contract-Aging-Calculus-OK.xlsx
Is it what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
I did an example for you.
http://speedy.sh/yrJdZ/21-07-2014-en-kioskea-Contract-Aging-Calculus-OK.xlsx
Is it what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
jessica2991
Posts
4
Registration date
Thursday July 17, 2014
Status
Member
Last seen
July 30, 2014
Jul 28, 2014 at 11:18 AM
Jul 28, 2014 at 11:18 AM
I am not able to open that file. Is there any way you can write the formula out? Thank you for your help!
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jul 28, 2014 at 12:49 PM
Jul 28, 2014 at 12:49 PM
jessica2991, Good afternoon.
I checked the link and it's OK!
A screenshot of the file:
C3 --> =IF(DATEDIF(B3,TODAY(),"d")<=5,"x","")
D3 --> =IF(AND(DATEDIF(B3,TODAY(),"d")>=6,DATEDIF(B3,TODAY(),"d")<=15),"x","")
E3 --> =IF(AND(DATEDIF(B3,TODAY(),"d")>=16,DATEDIF(B3,TODAY(),"d")<=30),"x","")
F3 --> =IF(AND(DATEDIF(B3,TODAY(),"d")>=31,DATEDIF(B3,TODAY(),"d")<=42),"x","")
G3 --> =IF(DATEDIF(B3,TODAY(),"d")>42,"x","")
Copy them down
C13 --> =CONT.SE(C3:C12;"X")
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
I checked the link and it's OK!
A screenshot of the file:
C3 --> =IF(DATEDIF(B3,TODAY(),"d")<=5,"x","")
D3 --> =IF(AND(DATEDIF(B3,TODAY(),"d")>=6,DATEDIF(B3,TODAY(),"d")<=15),"x","")
E3 --> =IF(AND(DATEDIF(B3,TODAY(),"d")>=16,DATEDIF(B3,TODAY(),"d")<=30),"x","")
F3 --> =IF(AND(DATEDIF(B3,TODAY(),"d")>=31,DATEDIF(B3,TODAY(),"d")<=42),"x","")
G3 --> =IF(DATEDIF(B3,TODAY(),"d")>42,"x","")
Copy them down
C13 --> =CONT.SE(C3:C12;"X")
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Didn't find the answer you are looking for?
Ask a question
jessica2991
Posts
4
Registration date
Thursday July 17, 2014
Status
Member
Last seen
July 30, 2014
Jul 30, 2014 at 01:34 PM
Jul 30, 2014 at 01:34 PM
Thank you very much! This was exactly what I needed!
Jul 21, 2014 at 11:02 AM
0-5 Days 6-15 Days 16-30 Days 31-42 Days >42 Days
X