Good day to all. I have a table with multiple conditions with specific amounts if conditions are met, but Im stymied on how to create the IF and/or formula since the conditions have min/max ranges. Hoping for some help Thanks a lot!
Sample table below:
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
<colgroup><col style="width: 100px"><col width="100"><col width="100"><col width="100"><col width="100"></colgroup><tbody>
</tbody>
So, if Emp gets a score between 80 to 84.9 and a rating between 4.7 to 4.79, the amount should return "500", so on and so forth. Im trying to create a formula using IF and/or or if anyone can help me with another formula Id appreciate it much.
Many thanks!
Ted
Sample table below:
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
Emp | 80 - 84.9 | 85 - 89.9 | 90 - 94.9 | 95 - 100 |
4.9 + | 700 | 1,200.00 | 2,000.00 | 3,000.00 |
4.8 - 4.89 | 700 | 1,200.00 | 1,800.00 | 2,800.00 |
4.7 - 4.79 | 500 | 1,000.00 | 1,600.00 | 2,600.00 |
4.69 - | 500 | 1,000.00 | 1,500.00 | 2,500.00 |
<colgroup><col style="width: 100px"><col width="100"><col width="100"><col width="100"><col width="100"></colgroup><tbody>
</tbody>
So, if Emp gets a score between 80 to 84.9 and a rating between 4.7 to 4.79, the amount should return "500", so on and so forth. Im trying to create a formula using IF and/or or if anyone can help me with another formula Id appreciate it much.
Many thanks!
Ted