Can someone please teach me how I would format a cell to do the following?:

If A1 is 16-37, then B1 is .25
If A1 is 38-52, then B1 is .50
If A1 is 53-59, then B1 is .75
If A1 is 60-75, then B1 is 1.00
If A1 is 76-97, then B1 is 1.25
If A1 is 98-112, then B1 is 1.50
If A1 is 113-119, then B1 is 1.75
If A1 is 120-157, then B1 is 2.00, etc.

There would actually be 16 conditions so that the result would go up to 4.00.
Ideally, the result would actually print in A1, but I don't think that's possible.


Thanks in advance for anyone willing to respond.