I am trying to limit the results of multiple IF functions and I almost got it to work with this formula:
=IF(AND(L2="Long-Term Disability - Reliance (Employee)",B2/12>=16667.67),16667.67,IF(AND(L2="Long-Term Disability - Reliance Buy Up (Employee)",B2/12>=25000),25000,IF(OR(L2<>"Long-Term Disability - Reliance (Employee)",L2<>"Long-Term Disability - Reliance Buy Up (Employee)"),P2,B2/12)))
But it isn't working for everyone and I can't understand why. Two people with the exact same scenario are pulling in different results.
Please help!
=IF(AND(L2="Long-Term Disability - Reliance (Employee)",B2/12>=16667.67),16667.67,IF(AND(L2="Long-Term Disability - Reliance Buy Up (Employee)",B2/12>=25000),25000,IF(OR(L2<>"Long-Term Disability - Reliance (Employee)",L2<>"Long-Term Disability - Reliance Buy Up (Employee)"),P2,B2/12)))
But it isn't working for everyone and I can't understand why. Two people with the exact same scenario are pulling in different results.
Please help!