08730000000BrGM
New Member
- Joined
- Feb 21, 2019
- Messages
- 17
Hello!
I am trying to use a DATEDIF formula to calculate a number that is then used to in an IF formula to generate a score. The issues is that for some of the DATEDIF calculations the EndDate is before the StartDate. When this happens, I have the formula generate a "0". I then use the outcome of the DATEDIF for an IF formula but when the outcome is "O" the IF formula doesn't work properly.
(DATEDIF Formula) =IF(AI5="","NO ONBOARDING DATA",(IFERROR(DATEDIF(T5,AI5,"d"),"0")))
(IF Formula) =IFERROR(IF(AJ5="","0.00",IF(AJ5<=7,"0.05",IF(AJ5<=14,"0.04",IF(AJ5<=21,"0.03",IF(AJ5<=365,"0.01",IF(AJ5>365,"0.00")))))),"0")
Why won't the "0" be considered in the IF(AJ5<=7,"0.05"??? How can I fix this so that all situations where the EndDate is in the past, the IF formula results in "0.05"?
Thank you!
I am trying to use a DATEDIF formula to calculate a number that is then used to in an IF formula to generate a score. The issues is that for some of the DATEDIF calculations the EndDate is before the StartDate. When this happens, I have the formula generate a "0". I then use the outcome of the DATEDIF for an IF formula but when the outcome is "O" the IF formula doesn't work properly.
(DATEDIF Formula) =IF(AI5="","NO ONBOARDING DATA",(IFERROR(DATEDIF(T5,AI5,"d"),"0")))
(IF Formula) =IFERROR(IF(AJ5="","0.00",IF(AJ5<=7,"0.05",IF(AJ5<=14,"0.04",IF(AJ5<=21,"0.03",IF(AJ5<=365,"0.01",IF(AJ5>365,"0.00")))))),"0")
Why won't the "0" be considered in the IF(AJ5<=7,"0.05"??? How can I fix this so that all situations where the EndDate is in the past, the IF formula results in "0.05"?
Thank you!