I have a very long IF formula that works fine itself, but when I record a macro with the formula it does not work. Here is how the formula part of the macro looks. What needs to be fixed? Thanks much
"=IF(RC[-1]=""Additional Info Received"",""Additional Info Received"",IF(RC[-1]=""Aetna Coding Error"",""Aetna Coding Error"",IF(RC[-1]=""Assignment"",""Assignment"",IF(RC[-1]=""Cap Deduct"",""Cap Deduct"",IF(RC[-1]=""Cap Deduct - Dedelegated"",""Cap Deduct - Dedelegated"",IF(RC[-1]=""Check Issued In Error"",""Check Issued In Error"",IF(RC[-1]=""Claims XTEN/Unbundling"",""Claims XTEN/Unbundling"",IF(RC[-1]=""COB"",""COB"",IF(RC[-1]=""COB Non-Health Insurance"",""COB Non-Health Insurance"",IF(RC[-1]=""COB-Commercial Not Known"",""COB-Commercial Not Known"",IF(RC[-1]=""COB-Ident Commercial Cov"",""COB-Ident Commercial Cov"",IF(RC[-1]=""COB-Ident MDCR Coverage"",""COB-Ident MDCR Coverage"",IF(RC[-1]=""COB-Medicare Not Known"",""COB-Medicare Not Known"",IF(RC[-1]=""Coinsurance Rate Error"",""Mbr OOP(copay/ded/coins)"",IF(RC[-1]=""Contract - Administration"",""Contract - Administration"",IF(RC[-1]=""Contract - Capitation"",""Contract - Capitation"",IF(RC[-1]=""Contract - Carve-Outs"",""Contract - Carve-Outs"",IF(RC[-1]=""Contract - Comments"",""Contract - Comments"",IF(RC[-1]=""Contract - DRG Facility"",""Contract - DRG Facility"",IF(RC[-1]=""Contract - Set-Up"",""Contract - Set-Up"",IF(RC[-1]=""Contract - Stop Loss"",""Contract - Stop Loss"",IF(RC[-1]=""Contracts & Rates"",""Contracts & Rates"",IF(RC[-1]=""Dental"",""Dental"",IF(RC[-1]=""Duplicates"",""Duplicates"",IF(RC[-1]=""Eligibility"",""Eligibility"",IF(RC[-1]=""External Vdr -Retro Term"",""External Vdr -Retro Term"",IF(RC[-1]=""External Vdr-Hi Cost RX"",""External Vdr-Hi Cost RX"",IF(RC[-1]=""External Vendor - COB"",""External Vendor - COB"",IF(RC[-1]=""External Vendor - DRG"",""External Vendor - DRG"",IF(RC[-1]=""External Vendor - HBA"",""External Vendor - HBA"",IF(RC[-1]=""External Vendor - Other"",""External Vendor - Other"",IF(RC[-1]=""External Vendor - Subro"",""External Vendor - Subro"",IF(RC[-1]=""External Vendor-Contract"",""External Vendor-Contract"",IF(RC[-1]=""External Vendor-Dupe"",""External Vendor-Dupe"",IF(RC[-1]=""External Vendor-Work Comp"",""External Vendor-Work Comp"",IF(RC[-1]=""Legislation"",""Legislation"",IF(RC[-1]=""Mbr OOP(copay/ded/coins)"",""Mbr OOP(copay/ded/coins)"",IF(RC[-1]=""Medical POB - Set-Up"",""Medical POB - Set-Up"",IF(RC[-1]=""Medical POB - Admin"",""Medical POB - Admin"",IF(RC[-1]=""Medicare"",""Medicare"",IF(RC[-1]=""Member copay/Ded/Coins"",""Mbr OOP(copay/ded/coins)"",IF(RC[-1]=""Other"",""Other"",IF(RC[-1]=""Other Dental"",""Other Dental"",IF(RC[-1]=""Plan of Benefits"",""Plan of Benefits"",IF(RC[-1]=""Plan Sponsor Specific"",""Plan Sponsor Specific"",IF(RC[-1]=""Policy - Auth/CXT"",""Policy - Auth/CXT"",IF(RC[-1]=""Policy - Claim Payment"",""Policy - Claim Payment"",IF(RC[-1]=""Provider Billing Error"",""Provider Billing Error"",IF(RC[-1]=""Provider Identifier"",""Provider Identifier"",IF(RC[-1]=""Provider Selection"",""Provider Selection"",IF(RC[-1]=""Provider Submission Error"",""Provider Submission Error"",IF(RC[-1]=""Replacement Check"",""Replacement Check"",IF(RC[-1]=""SIU"",""SIU"",IF(RC[-1]=""Subrogation"",""Subrogation"",IF(RC[-1]=""System"",""System"",IF(RC[-1]=""Termination"",""Termination"",IF(RC[-1]=""Workers Compensation"",""Workers Compensation"")))))))))))))))))))))))))))))))))))))))))))))))))))))))))"
"=IF(RC[-1]=""Additional Info Received"",""Additional Info Received"",IF(RC[-1]=""Aetna Coding Error"",""Aetna Coding Error"",IF(RC[-1]=""Assignment"",""Assignment"",IF(RC[-1]=""Cap Deduct"",""Cap Deduct"",IF(RC[-1]=""Cap Deduct - Dedelegated"",""Cap Deduct - Dedelegated"",IF(RC[-1]=""Check Issued In Error"",""Check Issued In Error"",IF(RC[-1]=""Claims XTEN/Unbundling"",""Claims XTEN/Unbundling"",IF(RC[-1]=""COB"",""COB"",IF(RC[-1]=""COB Non-Health Insurance"",""COB Non-Health Insurance"",IF(RC[-1]=""COB-Commercial Not Known"",""COB-Commercial Not Known"",IF(RC[-1]=""COB-Ident Commercial Cov"",""COB-Ident Commercial Cov"",IF(RC[-1]=""COB-Ident MDCR Coverage"",""COB-Ident MDCR Coverage"",IF(RC[-1]=""COB-Medicare Not Known"",""COB-Medicare Not Known"",IF(RC[-1]=""Coinsurance Rate Error"",""Mbr OOP(copay/ded/coins)"",IF(RC[-1]=""Contract - Administration"",""Contract - Administration"",IF(RC[-1]=""Contract - Capitation"",""Contract - Capitation"",IF(RC[-1]=""Contract - Carve-Outs"",""Contract - Carve-Outs"",IF(RC[-1]=""Contract - Comments"",""Contract - Comments"",IF(RC[-1]=""Contract - DRG Facility"",""Contract - DRG Facility"",IF(RC[-1]=""Contract - Set-Up"",""Contract - Set-Up"",IF(RC[-1]=""Contract - Stop Loss"",""Contract - Stop Loss"",IF(RC[-1]=""Contracts & Rates"",""Contracts & Rates"",IF(RC[-1]=""Dental"",""Dental"",IF(RC[-1]=""Duplicates"",""Duplicates"",IF(RC[-1]=""Eligibility"",""Eligibility"",IF(RC[-1]=""External Vdr -Retro Term"",""External Vdr -Retro Term"",IF(RC[-1]=""External Vdr-Hi Cost RX"",""External Vdr-Hi Cost RX"",IF(RC[-1]=""External Vendor - COB"",""External Vendor - COB"",IF(RC[-1]=""External Vendor - DRG"",""External Vendor - DRG"",IF(RC[-1]=""External Vendor - HBA"",""External Vendor - HBA"",IF(RC[-1]=""External Vendor - Other"",""External Vendor - Other"",IF(RC[-1]=""External Vendor - Subro"",""External Vendor - Subro"",IF(RC[-1]=""External Vendor-Contract"",""External Vendor-Contract"",IF(RC[-1]=""External Vendor-Dupe"",""External Vendor-Dupe"",IF(RC[-1]=""External Vendor-Work Comp"",""External Vendor-Work Comp"",IF(RC[-1]=""Legislation"",""Legislation"",IF(RC[-1]=""Mbr OOP(copay/ded/coins)"",""Mbr OOP(copay/ded/coins)"",IF(RC[-1]=""Medical POB - Set-Up"",""Medical POB - Set-Up"",IF(RC[-1]=""Medical POB - Admin"",""Medical POB - Admin"",IF(RC[-1]=""Medicare"",""Medicare"",IF(RC[-1]=""Member copay/Ded/Coins"",""Mbr OOP(copay/ded/coins)"",IF(RC[-1]=""Other"",""Other"",IF(RC[-1]=""Other Dental"",""Other Dental"",IF(RC[-1]=""Plan of Benefits"",""Plan of Benefits"",IF(RC[-1]=""Plan Sponsor Specific"",""Plan Sponsor Specific"",IF(RC[-1]=""Policy - Auth/CXT"",""Policy - Auth/CXT"",IF(RC[-1]=""Policy - Claim Payment"",""Policy - Claim Payment"",IF(RC[-1]=""Provider Billing Error"",""Provider Billing Error"",IF(RC[-1]=""Provider Identifier"",""Provider Identifier"",IF(RC[-1]=""Provider Selection"",""Provider Selection"",IF(RC[-1]=""Provider Submission Error"",""Provider Submission Error"",IF(RC[-1]=""Replacement Check"",""Replacement Check"",IF(RC[-1]=""SIU"",""SIU"",IF(RC[-1]=""Subrogation"",""Subrogation"",IF(RC[-1]=""System"",""System"",IF(RC[-1]=""Termination"",""Termination"",IF(RC[-1]=""Workers Compensation"",""Workers Compensation"")))))))))))))))))))))))))))))))))))))))))))))))))))))))))"