Q:

Want a cell to equal 1 of 3 values based on if another cell falls within 3 different ranges

What I want to do seems simple...but, I just cannot seem to find the correct function.I am sure this is easy for the folks on here!
I want a formula that does the following:
For Example:

When the cell value is equal to or greater than 1 or less than or equal to 3, the function cell should return a value of 35
When the cell value is greater than 3 or less than 6, the function cell should return a value of 30
When the cell value is equal to or greater than 6, the function cell should return a value of 25

That's it. I have been trying IF functions and combining AND functions but keep hitting errors.

A:

Try this:
=INDEX({35,30,25},MATCH(MAX(A1,0),{0,4,6},1))

A:

Covers negatives:
=5*(5+(A1<6)+(A1<4))

or not (returns 10 for less than 1 and 25 for more than 6):
 =5*(5*(A1>=1)+(A1<6)+(A1<4))

