If <$ then %, if >$$ then higher % formula?

Originally Posted by LKM Kevin

I may have described that wrong....

Nah, what happened was since you didn't bother to post an attachment for me to work with I worked in a fresh sheet, and was offset a column to the right compared to your example.

Just shift it over one.