I'm in column H and I first want to check the value in column A to determine
if it is over or under 80%
Example:
If the value in column A is 80% or greater, I don't want anything to show up
in column H.
If the value in column A is less than 80% AND column B is <= 1%, show ".5%"
in column H.
If the value in column A is less than 80% AND column B is between 1.1% and
2%, show "1%" in column H.
If the value in column A is less than 80% AND column B is between 2.1% and
3%, show "2%" in column H.
If the value in column A is less than 80% AND column B is = 3.1%, show "3%"
in column H.

Can someone help me with this one? Thanks in advance