IF Formulas with Dates
Closed
orodriguezjr
Posts
2
Registration date
Tuesday February 25, 2014
Status
Member
Last seen
February 25, 2014
-
Feb 25, 2014 at 01:21 PM
orodriguezjr Posts 2 Registration date Tuesday February 25, 2014 Status Member Last seen February 25, 2014 - Feb 25, 2014 at 04:08 PM
orodriguezjr Posts 2 Registration date Tuesday February 25, 2014 Status Member Last seen February 25, 2014 - Feb 25, 2014 at 04:08 PM
Related:
- IF Formulas with Dates
- Little alchemy formulas - Guide
- Spreadsheet formulas - Guide
- Ms excel marksheet formulas pdf - Guide
- Excel formulas number to words - Guide
- Defcon dates - Guide
2 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Feb 25, 2014 at 03:05 PM
Feb 25, 2014 at 03:05 PM
orodriguezjr, good afternoon.
I'm not sure if I understood well your doubt.
The logic function "AND" consider TRUE as a result, ONLY if ALL the internal conditions are checked as TRUE.
Your formula:
=(IF(AND(($A13>=R$2),($A13<=R$3)),$D13,0))
Suppose:
A13 = 10
R2 = 8
R3 = 12
Your formula accept a interval as TRUE
a) =(IF(AND(($A13>=R$2),($A13<=R$3)),$D13,0))
.......................10 >= 8.........10 <= 12
........................TRUE...............TRUE
then the CELL receives a D13 VALUE
A13 can be any value thru 8 to 12
Is this what you want?
I'm not sure if I understood well your doubt.
The logic function "AND" consider TRUE as a result, ONLY if ALL the internal conditions are checked as TRUE.
Your formula:
=(IF(AND(($A13>=R$2),($A13<=R$3)),$D13,0))
Suppose:
A13 = 10
R2 = 8
R3 = 12
Your formula accept a interval as TRUE
a) =(IF(AND(($A13>=R$2),($A13<=R$3)),$D13,0))
.......................10 >= 8.........10 <= 12
........................TRUE...............TRUE
then the CELL receives a D13 VALUE
A13 can be any value thru 8 to 12
Is this what you want?
orodriguezjr
Posts
2
Registration date
Tuesday February 25, 2014
Status
Member
Last seen
February 25, 2014
Feb 25, 2014 at 04:08 PM
Feb 25, 2014 at 04:08 PM
Hi, thanks for your prompt replay. I finally solved the problem, although I had to solve it in stages using the formula assistant from Excel. First I made sure the AND function was correct and then I added in the IF function.
As it turned out, the problem was not with the formula but with the Date format. What I found out is that if the date formats you're trying to compare are different (in this case one format was in Spanish and the other in US English) then you will either get a VALUE error or a wrong comparison. A 04/01/14 date, for example would read Jan 1 in Spanish and April 1 in US English.
Thanks for your time and interest.
Regards,
As it turned out, the problem was not with the formula but with the Date format. What I found out is that if the date formats you're trying to compare are different (in this case one format was in Spanish and the other in US English) then you will either get a VALUE error or a wrong comparison. A 04/01/14 date, for example would read Jan 1 in Spanish and April 1 in US English.
Thanks for your time and interest.
Regards,
