Hello,
I am trying to automate some parts of a spreadsheet. Essentially I have 2 Cells for example A1 and A2. In cell A1 I would enter a number in it anywhere from .01-100. And in A2 I have to rate it a 1 - 5 based on ranges.
So if ex A1 = 1-25 it's a 1, 25-49.99 is a 2, and other ranges. What...