Hi,
I needed some help with this range I needed to write a formula for. I saw that a formula or a vlookup range table can be set up so that these ranges can be changed without changing the formula. I'd really appreciate any help with the formula first, and the vlookup table setup would help as well.
Here are the ranges:
Aaa <0.75x
Aa ≥0.75x - 1.5x
A ≥1.5x - 2.5x
Baa ≥2.5x - 3.5x
Ba ≥3.5x - 4.5x
B ≥4.5x - 6.0x
Caa ≥6.0x - 8.0x
Ca ≥8.0x [or <0.0x]
Thanks
Bookmarks