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 type of formula would I use because my if functions are getting crazy and have errors and I can get it to work. Only time it came out with something it just says FALSE.
Please help
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 type of formula would I use because my if functions are getting crazy and have errors and I can get it to work. Only time it came out with something it just says FALSE.
Please help