Re: Correct Nested IF showing blank instead of result
0
1885
1
I’m building something for my client wherein they choose a single-select and it will show results for 6 total fields based off that selection:
i.e. If x = selection1, then 1 = A, 2 = B, 3 = C, 4 = D, 5 = E, 6 = F
If x = selection 2, then 1 = B, 2 = C, 3 = D, 4 = E, 5 = F, 6 = G
If x = selection 3, then 1 = C, 2 = D, 3 = E, 4 = F, 5 = G, 6 = H
I’ve included screenshots and my formulas below and I cannot figure out WHY “Round 3” shows blank when I’m like 100% positive that the formula is correct. Please help!
Formula 1 for “Round 1”:
IF(T({Choose Item Type & Round}) = “charge-offDOLA”, “remove this account due to the fact that there are different dates last active reported. How can there be different dates when this is what stipulates when the account naturally falls off? You can’t report different months and different years!”,
IF(T({Choose Item Type & Round}) = “charge-offDOLP”, “date last paid shows mutliple dates and this makes it look like I paid when I didn’t and didn’t when I paid. How is that possible? How can there be years between bureaus? You need to remove this account immediately for inaccuracy!”,
IF(T({Choose Item Type & Round}) = “charge-offMONTHPAY”, “you cannot report a monthly payment on a closed account. There should not be anything listed here after this account was closed. Remove for violation.”,
IF(T({Choose Item Type & Round}) = “charge-offPAYHIST”, “remove for inaccurate payment history! How can 1 bureau report that I was on time while another reports that I was late and the 3rd reports nothing at all? I was either late or on time. There are mutiple dates listed like this.”,
IF(T({Choose Item Type & Round}) = “charge-offBALANCE”, “I don’t owe the balance listed and unless you have paperwork that can be furnished to prove otherwise. Remove for inaccuracy”,
IF(T({Choose Item Type & Round}) = “charge-off1STDELINQ”, “1st date of delinquency is inaccurate and this account needs to be removed because of it. This date throws off the entire history of this account as well as date last active. Remove immediately.”,
IF(T({Choose Item Type & Round}) = “charge-offHIGHBAL”, “high balance is lower than the balance [or if that is not true] the high balance on this account is inconsistent from bureau to bureau and there can only be 1 high balance on this account! Unless you can provide documentation directly from the creditor stipulating that the information you are reporting is correct including the exact dollar amount, this must be removed for inaccuracy.”,
IF(T({Choose Item Type & Round}) = “charge-offOPEND”, “open date reflects multiple inaccuracies and this account must be removed: mutliple dates reported as date opened and incorrect date reported by your organization.”,
IF(T({Choose Item Type & Round}) = BLANK(),BLANK())))))))))
Formula for "Round 2:
IF(T({Round 1}) = “remove this account due to the fact that there are different dates last active reported. How can there be different dates when this is what stipulates when the account naturally falls off? You can’t report different months and different years!”, "date last paid shows mutliple dates and this makes it look like I paid when I didn’t and didn’t when I paid. How is that possible? How can there be years between bureaus? You need to remove this account immediately for inaccuracy! ",
IF(T({Round 1}) = “date last paid shows mutliple dates and this makes it look like I paid when I didn’t and didn’t when I paid. How is that possible? How can there be years between bureaus? You need to remove this account immediately for inaccuracy!”, “you cannot report a monthly payment on a closed account. There should not be anything listed here after this account was closed. Remove for violation.”,
IF(T({Round 1}) = “you cannot report a monthly payment on a closed account. There should not be anything listed here after this account was closed. Remove for violation.”, “remove for inaccurate payment history! How can 1 bureau report that I was on time while another reports that I was late and the 3rd reports nothing at all? I was either late or on time. There are mutiple dates listed like this.”,
IF(T({Round 1}) = “remove for inaccurate payment history! How can 1 bureau report that I was on time while another reports that I was late and the 3rd reports nothing at all? I was either late or on time. There are mutiple dates listed like this.”, “I don’t owe the balance listed and unless you have paperwork that can be furnished to prove otherwise. Remove for inaccuracy”,
IF(T({Round 1}) = “I don’t owe the balance listed and unless you have paperwork that can be furnished to prove otherwise. Remove for inaccuracy”, “1st date of delinquency is inaccurate and this account needs to be removed because of it. This date throws off the entire history of this account as well as date last active. Remove immediately.”,
IF(T({Round 1}) = “1st date of delinquency is inaccurate and this account needs to be removed because of it. This date throws off the entire history of this account as well as date last active. Remove immediately.”, “high balance is lower than the balance [or if that is not true] the high balance on this account is inconsistent from bureau to bureau and there can only be 1 high balance on this account! Unless you can provide documentation directly from the creditor stipulating that the information you are reporting is correct including the exact dollar amount, this must be removed for inaccuracy.”,
IF(T({Round 1}) = “high balance is lower than the balance [or if that is not true] the high balance on this account is inconsistent from bureau to bureau and there can only be 1 high balance on this account! Unless you can provide documentation directly from the creditor stipulating that the information you are reporting is correct including the exact dollar amount, this must be removed for inaccuracy.”, “open date reflects multiple inaccuracies and this account must be removed: mutliple dates reported as date opened and incorrect date reported by your organization.”,
IF(T({Round 1}) = “open date reflects multiple inaccuracies and this account must be removed: mutliple dates reported as date opened and incorrect date reported by your organization.”, “I don’t believe that you did an independent investigation and this account needs to be removed unless you can prove that you did not just parrot what the creditor told you. If you only utilized an electronic response, then this account was not legally investigated and must be removed.”,
IF(T({Round 1}) = BLANK(),BLANK())))))))))
Formula for “Round 3” *** this is where the problem is:
IF(T({Round 2}) = “date last paid shows mutliple dates and this makes it look like I paid when I didn’t and didn’t when I paid. How is that possible? How can there be years between bureaus? You need to remove this account immediately for inaccuracy!”, “you cannot report a monthly payment on a closed account. There should not be anything listed here after this account was closed. Remove for violation.”,
IF(T({Round 2}) = “you cannot report a monthly payment on a closed account. There should not be anything listed here after this account was closed. Remove for violation.”, “remove for inaccurate payment history! How can 1 bureau report that I was on time while another reports that I was late and the 3rd reports nothing at all? I was either late or on time. There are mutiple dates listed like this.”,
IF(T({Round 2}) = “remove for inaccurate payment history! How can 1 bureau report that I was on time while another reports that I was late and the 3rd reports nothing at all? I was either late or on time. There are mutiple dates listed like this.”, “I don’t owe the balance listed and unless you have paperwork that can be furnished to prove otherwise. Remove for inaccuracy”,
IF(T({Round 2}) = “I don’t owe the balance listed and unless you have paperwork that can be furnished to prove otherwise. Remove for inaccuracy”, “1st date of delinquency is inaccurate and this account needs to be removed because of it. This date throws off the entire history of this account as well as date last active. Remove immediately.”,
IF(T({Round 2}) = “1st date of delinquency is inaccurate and this account needs to be removed because of it. This date throws off the entire history of this account as well as date last active. Remove immediately.”, “high balance is lower than the balance [or if that is not true] the high balance on this account is inconsistent from bureau to bureau and there can only be 1 high balance on this account! Unless you can provide documentation directly from the creditor stipulating that the information you are reporting is correct including the exact dollar amount, this must be removed for inaccuracy.”,
IF(T({Round 2}) = “high balance is lower than the balance [or if that is not true] the high balance on this account is inconsistent from bureau to bureau and there can only be 1 high balance on this account! Unless you can provide documentation directly from the creditor stipulating that the information you are reporting is correct including the exact dollar amount, this must be removed for inaccuracy.”, “open date reflects multiple inaccuracies and this account must be removed: mutliple dates reported as date opened and incorrect date reported by your organization.”,
IF(T({Round 2}) = “open date reflects multiple inaccuracies and this account must be removed: mutliple dates reported as date opened and incorrect date reported by your organization.”, “I don’t believe that you did an independent investigation and this account needs to be removed unless you can prove that you did not just parrot what the creditor told you. If you only utilized an electronic response, then this account was not legally investigated and must be removed.”,
IF(T({Round 2}) = “I don’t believe that you did an independent investigation and this account needs to be removed unless you can prove that you did not just parrot what the creditor told you. If you only utilized an electronic response, then this account was not legally investigated and must be removed.”, “Please send me everything that you used during this investigation to determine the accuracy of this account. Additionally, I would like to see a detailed report that provides the names, dates and method of verification. If this cannot be provided within 15 days, this account is falsely reported and must be removed for violation.”,
IF(T({Round 2}) = BLANK(),BLANK())))))))))
sorry but…
these are linked and are not showing and idk what it is:
formulas:
IF({Round 4} = D, E,
IF({Round 4} = E, F,
IF({Round 4} = F, G,
IF({Round 4} = G, H,
IF({Round 4} = H, I,
IF({Round 4} = I, J,
IF({Round 4} = J, K,
IF({Round 4} = K, L,
IF({Round 4} = L, M,
IF({Round 4} = M, N))))))))))
IF({Round 5} = E, F,
IF({Round 5} = F, G,
IF({Round 5} = G, H,
IF({Round 5} = H, I,
IF({Round 5} = I, J,
IF({Round 5} = J, K,
IF({Round 5} = K, L,
IF({Round 5} = L, M,
IF({Round 5} = M, N,
IF({Round 5} = N, O))))))))))
