IF formula or possible other formula help

[dkliedk]

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

 

[godsaaint]

Assuming for example 1:0-0.99, 2:1-24.99, 3:25-49.99, 4:50-74.99, 5:75-100. Tweak the formula based on the real ranges.

=IF(A1<1,"1",IF(A1<25,"2",IF(A1<50,"3",IF(A1<75,"4",IF(A1<=100,"5",)))))

 

[dkliedk]

Ex.
If cell A1 is 25-45 A2 is 6
if cell A1 is 45-65 or 15-25 A2 is a 7
If cell A1 is 100-150 or 4-8 A2 is 10

is it the similar concept or would it be need to be written differently

 

[dkliedk]

Sorry I meant to prefece it with saying in the above scenario would it be written
the same since it's multiple ranges could be the same number instead of one range? or would I need multiple functions?