Brustigian
New Member
- Joined
- Mar 1, 2013
- Messages
- 23
Hello, I'm asking for help with a Match/Index formula. The formula would find the correct factor in the table. The data in the table is AGE, RATE, & Factor. The data is arranged in the table with the AGE in the far left column. RATES are distributed in increments of 1/8ths in the top row. The FACTOR is located in the array. Example, what is the correct Factor for a person age 75 at an interest rate of 7.375? Answer: 0.382
Thank you for your interest, Bob
<tbody>
</tbody>
Thank you for your interest, Bob
3.000 | 3.125 | 3.250 | 3.375 | 3.500 | 3.625 | 3.750 | 3.875 | 4.000 | 4.125 | 4.250 | 4.375 | 4.500 | 4.625 | 4.750 | 4.875 | 5.000 | 5.125 | 5.250 | 5.375 | 5.500 | 5.625 | 5.750 | 5.875 | 6.000 | 6.125 | 6.250 | 6.375 | 6.500 | 6.625 | 6.750 | 6.875 | 7.000 | 7.125 | 7.250 | 7.375 | 7.500 | 7.625 | 7.750 | 7.875 | |
62 | 0.524 | 0.524 | 0.524 | 0.524 | 0.524 | 0.524 | 0.524 | 0.524 | 0.524 | 0.524 | 0.524 | 0.524 | 0.524 | 0.524 | 0.524 | 0.524 | 0.524 | 0.508 | 0.491 | 0.475 | 0.459 | 0.443 | 0.427 | 0.411 | 0.395 | 0.384 | 0.374 | 0.364 | 0.353 | 0.343 | 0.332 | 0.322 | 0.312 | 0.302 | 0.293 | 0.283 | 0.274 | 0.264 | 0.255 | 0.246 |
63 | 0.530 | 0.530 | 0.530 | 0.530 | 0.530 | 0.530 | 0.530 | 0.530 | 0.530 | 0.530 | 0.530 | 0.530 | 0.530 | 0.530 | 0.530 | 0.530 | 0.530 | 0.514 | 0.498 | 0.482 | 0.466 | 0.449 | 0.433 | 0.417 | 0.401 | 0.391 | 0.380 | 0.370 | 0.360 | 0.349 | 0.339 | 0.329 | 0.318 | 0.309 | 0.300 | 0.290 | 0.281 | 0.271 | 0.262 | 0.253 |
64 | 0.536 | 0.536 | 0.536 | 0.536 | 0.536 | 0.536 | 0.536 | 0.536 | 0.536 | 0.536 | 0.536 | 0.536 | 0.536 | 0.536 | 0.536 | 0.536 | 0.536 | 0.520 | 0.504 | 0.488 | 0.472 | 0.456 | 0.440 | 0.423 | 0.407 | 0.397 | 0.387 | 0.376 | 0.366 | 0.356 | 0.345 | 0.335 | 0.325 | 0.316 | 0.306 | 0.297 | 0.288 | 0.278 | 0.269 | 0.260 |
65 | 0.542 | 0.542 | 0.542 | 0.542 | 0.542 | 0.542 | 0.542 | 0.542 | 0.542 | 0.542 | 0.542 | 0.542 | 0.542 | 0.542 | 0.542 | 0.542 | 0.542 | 0.526 | 0.510 | 0.494 | 0.478 | 0.462 | 0.446 | 0.430 | 0.414 | 0.403 | 0.393 | 0.383 | 0.373 | 0.362 | 0.352 | 0.342 | 0.332 | 0.322 | 0.313 | 0.304 | 0.294 | 0.285 | 0.276 | 0.267 |
66 | 0.549 | 0.549 | 0.549 | 0.549 | 0.549 | 0.549 | 0.549 | 0.549 | 0.549 | 0.549 | 0.549 | 0.549 | 0.549 | 0.549 | 0.549 | 0.549 | 0.549 | 0.533 | 0.517 | 0.501 | 0.485 | 0.469 | 0.453 | 0.437 | 0.421 | 0.411 | 0.400 | 0.390 | 0.380 | 0.369 | 0.359 | 0.349 | 0.338 | 0.329 | 0.320 | 0.310 | 0.301 | 0.292 | 0.283 | 0.274 |
67 | 0.556 | 0.556 | 0.556 | 0.556 | 0.556 | 0.556 | 0.556 | 0.556 | 0.556 | 0.556 | 0.556 | 0.556 | 0.556 | 0.556 | 0.556 | 0.556 | 0.556 | 0.540 | 0.524 | 0.508 | 0.492 | 0.476 | 0.460 | 0.444 | 0.429 | 0.418 | 0.408 | 0.397 | 0.387 | 0.376 | 0.366 | 0.355 | 0.345 | 0.336 | 0.326 | 0.317 | 0.308 | 0.299 | 0.290 | 0.281 |
68 | 0.562 | 0.562 | 0.562 | 0.562 | 0.562 | 0.562 | 0.562 | 0.562 | 0.562 | 0.562 | 0.562 | 0.562 | 0.562 | 0.562 | 0.562 | 0.562 | 0.562 | 0.547 | 0.531 | 0.515 | 0.499 | 0.483 | 0.468 | 0.452 | 0.436 | 0.425 | 0.415 | 0.404 | 0.394 | 0.383 | 0.373 | 0.362 | 0.351 | 0.342 | 0.333 | 0.324 | 0.315 | 0.306 | 0.297 | 0.288 |
69 | 0.569 | 0.569 | 0.569 | 0.569 | 0.569 | 0.569 | 0.569 | 0.569 | 0.569 | 0.569 | 0.569 | 0.569 | 0.569 | 0.569 | 0.569 | 0.569 | 0.569 | 0.553 | 0.538 | 0.522 | 0.506 | 0.491 | 0.475 | 0.459 | 0.443 | 0.433 | 0.422 | 0.411 | 0.401 | 0.390 | 0.379 | 0.369 | 0.358 | 0.349 | 0.340 | 0.331 | 0.322 | 0.313 | 0.304 | 0.295 |
70 | 0.576 | 0.576 | 0.576 | 0.576 | 0.576 | 0.576 | 0.576 | 0.576 | 0.576 | 0.576 | 0.576 | 0.576 | 0.576 | 0.576 | 0.576 | 0.576 | 0.576 | 0.560 | 0.544 | 0.529 | 0.513 | 0.498 | 0.482 | 0.467 | 0.451 | 0.440 | 0.429 | 0.419 | 0.408 | 0.397 | 0.386 | 0.376 | 0.365 | 0.356 | 0.347 | 0.338 | 0.329 | 0.320 | 0.311 | 0.302 |
71 | 0.583 | 0.583 | 0.583 | 0.583 | 0.583 | 0.583 | 0.583 | 0.583 | 0.583 | 0.583 | 0.583 | 0.583 | 0.583 | 0.583 | 0.583 | 0.583 | 0.583 | 0.568 | 0.552 | 0.537 | 0.521 | 0.506 | 0.490 | 0.475 | 0.459 | 0.448 | 0.438 | 0.427 | 0.416 | 0.406 | 0.395 | 0.384 | 0.374 | 0.365 | 0.356 | 0.346 | 0.337 | 0.328 | 0.319 | 0.310 |
72 | 0.591 | 0.591 | 0.591 | 0.591 | 0.591 | 0.591 | 0.591 | 0.591 | 0.591 | 0.591 | 0.591 | 0.591 | 0.591 | 0.591 | 0.591 | 0.591 | 0.591 | 0.575 | 0.560 | 0.545 | 0.529 | 0.514 | 0.498 | 0.483 | 0.467 | 0.457 | 0.446 | 0.436 | 0.425 | 0.414 | 0.404 | 0.393 | 0.383 | 0.374 | 0.364 | 0.355 | 0.346 | 0.337 | 0.328 | 0.319 |
73 | 0.599 | 0.599 | 0.599 | 0.599 | 0.599 | 0.599 | 0.599 | 0.599 | 0.599 | 0.599 | 0.599 | 0.599 | 0.599 | 0.599 | 0.599 | 0.599 | 0.599 | 0.583 | 0.568 | 0.552 | 0.537 | 0.522 | 0.506 | 0.491 | 0.475 | 0.465 | 0.454 | 0.444 | 0.434 | 0.423 | 0.413 | 0.402 | 0.392 | 0.383 | 0.373 | 0.364 | 0.355 | 0.346 | 0.337 | 0.327 |
74 | 0.606 | 0.606 | 0.606 | 0.606 | 0.606 | 0.606 | 0.606 | 0.606 | 0.606 | 0.606 | 0.606 | 0.606 | 0.606 | 0.606 | 0.606 | 0.606 | 0.606 | 0.591 | 0.575 | 0.560 | 0.545 | 0.530 | 0.514 | 0.499 | 0.484 | 0.473 | 0.463 | 0.452 | 0.442 | 0.432 | 0.421 | 0.411 | 0.401 | 0.391 | 0.382 | 0.373 | 0.364 | 0.355 | 0.345 | 0.336 |
75 | 0.614 | 0.614 | 0.614 | 0.614 | 0.614 | 0.614 | 0.614 | 0.614 | 0.614 | 0.614 | 0.614 | 0.614 | 0.614 | 0.614 | 0.614 | 0.614 | 0.614 | 0.598 | 0.583 | 0.568 | 0.553 | 0.537 | 0.522 | 0.507 | 0.492 | 0.481 | 0.471 | 0.461 | 0.451 | 0.440 | 0.430 | 0.420 | 0.410 | 0.400 | 0.391 | 0.382 | 0.373 | 0.363 | 0.354 | 0.345 |
76 | 0.622 | 0.622 | 0.622 | 0.622 | 0.622 | 0.622 | 0.622 | 0.622 | 0.622 | 0.622 | 0.622 | 0.622 | 0.622 | 0.622 | 0.622 | 0.622 | 0.622 | 0.607 | 0.592 | 0.577 | 0.562 | 0.547 | 0.531 | 0.516 | 0.501 | 0.491 | 0.481 | 0.470 | 0.460 | 0.450 | 0.440 | 0.429 | 0.419 | 0.410 | 0.401 | 0.392 | 0.383 | 0.373 | 0.364 | 0.355 |
77 | 0.631 | 0.631 | 0.631 | 0.631 | 0.631 | 0.631 | 0.631 | 0.631 | 0.631 | 0.631 | 0.631 | 0.631 | 0.631 | 0.631 | 0.631 | 0.631 | 0.631 | 0.616 | 0.601 | 0.586 | 0.571 | 0.556 | 0.541 | 0.526 | 0.510 | 0.500 | 0.490 | 0.480 | 0.469 | 0.459 | 0.449 | 0.439 | 0.428 | 0.419 | 0.410 | 0.401 | 0.392 | 0.383 | 0.375 | 0.366 |
78 | 0.640 | 0.640 | 0.640 | 0.640 | 0.640 | 0.640 | 0.640 | 0.640 | 0.640 | 0.640 | 0.640 | 0.640 | 0.640 | 0.640 | 0.640 | 0.640 | 0.640 | 0.625 | 0.610 | 0.595 | 0.580 | 0.565 | 0.550 | 0.535 | 0.520 | 0.510 | 0.499 | 0.489 | 0.479 | 0.469 | 0.458 | 0.448 | 0.438 | 0.429 | 0.420 | 0.411 | 0.402 | 0.394 | 0.385 | 0.376 |
79 | 0.648 | 0.648 | 0.648 | 0.648 | 0.648 | 0.648 | 0.648 | 0.648 | 0.648 | 0.648 | 0.648 | 0.648 | 0.648 | 0.648 | 0.648 | 0.648 | 0.648 | 0.633 | 0.618 | 0.604 | 0.589 | 0.574 | 0.559 | 0.544 | 0.529 | 0.519 | 0.509 | 0.498 | 0.488 | 0.478 | 0.468 | 0.457 | 0.447 | 0.438 | 0.430 | 0.421 | 0.412 | 0.404 | 0.395 | 0.386 |
80 | 0.657 | 0.657 | 0.657 | 0.657 | 0.657 | 0.657 | 0.657 | 0.657 | 0.657 | 0.657 | 0.657 | 0.657 | 0.657 | 0.657 | 0.657 | 0.657 | 0.657 | 0.642 | 0.627 | 0.612 | 0.598 | 0.583 | 0.568 | 0.553 | 0.539 | 0.528 | 0.518 | 0.508 | 0.498 | 0.487 | 0.477 | 0.467 | 0.457 | 0.448 | 0.439 | 0.431 | 0.422 | 0.414 | 0.405 | 0.397 |
81 | 0.665 | 0.665 | 0.665 | 0.665 | 0.665 | 0.665 | 0.665 | 0.665 | 0.665 | 0.665 | 0.665 | 0.665 | 0.665 | 0.665 | 0.665 | 0.665 | 0.665 | 0.651 | 0.636 | 0.621 | 0.607 | 0.592 | 0.578 | 0.563 | 0.549 | 0.539 | 0.529 | 0.518 | 0.508 | 0.498 | 0.488 | 0.478 | 0.468 | 0.459 | 0.451 | 0.442 | 0.434 | 0.425 | 0.417 | 0.408 |
82 | 0.674 | 0.674 | 0.674 | 0.674 | 0.674 | 0.674 | 0.674 | 0.674 | 0.674 | 0.674 | 0.674 | 0.674 | 0.674 | 0.674 | 0.674 | 0.674 | 0.674 | 0.659 | 0.645 | 0.631 | 0.616 | 0.602 | 0.588 | 0.573 | 0.559 | 0.549 | 0.539 | 0.529 | 0.519 | 0.509 | 0.499 | 0.489 | 0.479 | 0.471 | 0.462 | 0.454 | 0.445 | 0.436 | 0.428 | 0.419 |
83 | 0.682 | 0.682 | 0.682 | 0.682 | 0.682 | 0.682 | 0.682 | 0.682 | 0.682 | 0.682 | 0.682 | 0.682 | 0.682 | 0.682 | 0.682 | 0.682 | 0.682 | 0.668 | 0.654 | 0.640 | 0.625 | 0.611 | 0.597 | 0.583 | 0.569 | 0.559 | 0.549 | 0.540 | 0.530 | 0.520 | 0.510 | 0.500 | 0.491 | 0.482 | 0.473 | 0.465 | 0.456 | 0.448 | 0.439 | 0.431 |
84 | 0.690 | 0.690 | 0.690 | 0.690 | 0.690 | 0.690 | 0.690 | 0.690 | 0.690 | 0.690 | 0.690 | 0.690 | 0.690 | 0.690 | 0.690 | 0.690 | 0.690 | 0.676 | 0.663 | 0.649 | 0.635 | 0.621 | 0.607 | 0.593 | 0.579 | 0.570 | 0.560 | 0.550 | 0.541 | 0.531 | 0.521 | 0.512 | 0.502 | 0.493 | 0.485 | 0.476 | 0.468 | 0.459 | 0.451 | 0.442 |
85 | 0.699 | 0.699 | 0.699 | 0.699 | 0.699 | 0.699 | 0.699 | 0.699 | 0.699 | 0.699 | 0.699 | 0.699 | 0.699 | 0.699 | 0.699 | 0.699 | 0.699 | 0.685 | 0.671 | 0.658 | 0.644 | 0.630 | 0.617 | 0.603 | 0.589 | 0.580 | 0.570 | 0.561 | 0.551 | 0.542 | 0.532 | 0.523 | 0.513 | 0.505 | 0.496 | 0.488 | 0.479 | 0.470 | 0.462 | 0.453 |
86 | 0.709 | 0.709 | 0.709 | 0.709 | 0.709 | 0.709 | 0.709 | 0.709 | 0.709 | 0.709 | 0.709 | 0.709 | 0.709 | 0.709 | 0.709 | 0.709 | 0.709 | 0.695 | 0.682 | 0.668 | 0.655 | 0.641 | 0.628 | 0.615 | 0.601 | 0.592 | 0.582 | 0.573 | 0.564 | 0.554 | 0.545 | 0.535 | 0.526 | 0.518 | 0.509 | 0.501 | 0.492 | 0.484 | 0.476 | 0.467 |
87 | 0.719 | 0.719 | 0.719 | 0.719 | 0.719 | 0.719 | 0.719 | 0.719 | 0.719 | 0.719 | 0.719 | 0.719 | 0.719 | 0.719 | 0.719 | 0.719 | 0.719 | 0.706 | 0.692 | 0.679 | 0.666 | 0.653 | 0.639 | 0.626 | 0.613 | 0.604 | 0.594 | 0.585 | 0.576 | 0.567 | 0.557 | 0.548 | 0.539 | 0.531 | 0.522 | 0.514 | 0.506 | 0.498 | 0.489 | 0.481 |
88 | 0.729 | 0.729 | 0.729 | 0.729 | 0.729 | 0.729 | 0.729 | 0.729 | 0.729 | 0.729 | 0.729 | 0.729 | 0.729 | 0.729 | 0.729 | 0.729 | 0.729 | 0.716 | 0.703 | 0.690 | 0.677 | 0.664 | 0.651 | 0.638 | 0.625 | 0.615 | 0.606 | 0.597 | 0.588 | 0.579 | 0.570 | 0.561 | 0.552 | 0.544 | 0.536 | 0.528 | 0.519 | 0.511 | 0.503 | 0.495 |
89 | 0.739 | 0.739 | 0.739 | 0.739 | 0.739 | 0.739 | 0.739 | 0.739 | 0.739 | 0.739 | 0.739 | 0.739 | 0.739 | 0.739 | 0.739 | 0.739 | 0.739 | 0.726 | 0.714 | 0.701 | 0.688 | 0.675 | 0.662 | 0.649 | 0.636 | 0.627 | 0.618 | 0.609 | 0.600 | 0.592 | 0.583 | 0.574 | 0.565 | 0.557 | 0.549 | 0.541 | 0.533 | 0.525 | 0.517 | 0.509 |
90 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.737 | 0.724 | 0.711 | 0.699 | 0.686 | 0.673 | 0.661 | 0.648 | 0.639 | 0.630 | 0.622 | 0.613 | 0.604 | 0.595 | 0.586 | 0.578 | 0.570 | 0.562 | 0.554 | 0.546 | 0.539 | 0.531 | 0.523 |
91 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.737 | 0.724 | 0.711 | 0.699 | 0.686 | 0.673 | 0.661 | 0.648 | 0.639 | 0.630 | 0.622 | 0.613 | 0.604 | 0.595 | 0.586 | 0.578 | 0.570 | 0.562 | 0.554 | 0.546 | 0.539 | 0.531 | 0.523 |
92 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.737 | 0.724 | 0.711 | 0.699 | 0.686 | 0.673 | 0.661 | 0.648 | 0.639 | 0.630 | 0.622 | 0.613 | 0.604 | 0.595 | 0.586 | 0.578 | 0.570 | 0.562 | 0.554 | 0.546 | 0.539 | 0.531 | 0.523 |
93 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.737 | 0.724 | 0.711 | 0.699 | 0.686 | 0.673 | 0.661 | 0.648 | 0.639 | 0.630 | 0.622 | 0.613 | 0.604 | 0.595 | 0.586 | 0.578 | 0.570 | 0.562 | 0.554 | 0.546 | 0.539 | 0.531 | 0.523 |
94 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.737 | 0.724 | 0.711 | 0.699 | 0.686 | 0.673 | 0.661 | 0.648 | 0.639 | 0.630 | 0.622 | 0.613 | 0.604 | 0.595 | 0.586 | 0.578 | 0.570 | 0.562 | 0.554 | 0.546 | 0.539 | 0.531 | 0.523 |
95 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.737 | 0.724 | 0.711 | 0.699 | 0.686 | 0.673 | 0.661 | 0.648 | 0.639 | 0.630 | 0.622 | 0.613 | 0.604 | 0.595 | 0.586 | 0.578 | 0.570 | 0.562 | 0.554 | 0.546 | 0.539 | 0.531 | 0.523 |
96 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.737 | 0.724 | 0.711 | 0.699 | 0.686 | 0.673 | 0.661 | 0.648 | 0.639 | 0.630 | 0.622 | 0.613 | 0.604 | 0.595 | 0.586 | 0.578 | 0.570 | 0.562 | 0.554 | 0.546 | 0.539 | 0.531 | 0.523 |
97 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.737 | 0.724 | 0.711 | 0.699 | 0.686 | 0.673 | 0.661 | 0.648 | 0.639 | 0.630 | 0.622 | 0.613 | 0.604 | 0.595 | 0.586 | 0.578 | 0.570 | 0.562 | 0.554 | 0.546 | 0.539 | 0.531 | 0.523 |
98 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.737 | 0.724 | 0.711 | 0.699 | 0.686 | 0.673 | 0.661 | 0.648 | 0.639 | 0.630 | 0.622 | 0.613 | 0.604 | 0.595 | 0.586 | 0.578 | 0.570 | 0.562 | 0.554 | 0.546 | 0.539 | 0.531 | 0.523 |
99 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.750 | 0.737 | 0.724 | 0.711 | 0.699 | 0.686 | 0.673 | 0.661 | 0.648 | 0.639 | 0.630 | 0.622 | 0.613 | 0.604 | 0.595 | 0.586 | 0.578 | 0.570 | 0.562 | 0.554 | 0.546 | 0.539 | 0.531 | 0.523 |
<tbody>
</tbody>