RedBirdin96
New Member
- Joined
- May 12, 2006
- Messages
- 19
I want to use solver to find when the two solutions for when the following if statements are equal:
IF($K2>=B$4,IF(B$4+($K2-B$4)*B$5>=B$6,B$6+12*$B$3,12*B$3+B$4+($K2-B$4)*B$5),12*B$3+$K2)
=IF($K2>=C$4,IF(C$4+($K2-C$4)*C$5>=C$6,C$6+12*$C$3,12*C$3+C$4+($K2-C$4)*C$5),12*C$3+$K2)
by varying the contents of K2
here is the rest of my inputs (sorry I did not figure out how to post it as an image/chart):
Plan A Plan B
Premium: 400 150
Deductible: 0 3500
Co-pay: 10% 20%
Out of Pocket Max: 5000 5000
IF($K2>=B$4,IF(B$4+($K2-B$4)*B$5>=B$6,B$6+12*$B$3,12*B$3+B$4+($K2-B$4)*B$5),12*B$3+$K2)
=IF($K2>=C$4,IF(C$4+($K2-C$4)*C$5>=C$6,C$6+12*$C$3,12*C$3+C$4+($K2-C$4)*C$5),12*C$3+$K2)
by varying the contents of K2
here is the rest of my inputs (sorry I did not figure out how to post it as an image/chart):
Plan A Plan B
Premium: 400 150
Deductible: 0 3500
Co-pay: 10% 20%
Out of Pocket Max: 5000 5000