darblooz wrote:
Off course, sorry.

Here's the part i edited.

Let's say i do this:
I put the number 0 in CELL A1 ----- CELL A2 automatically becomes 0.4
CELL A1 = 0 to / or equal to 1.25 ----- CELL A2 = 1
CELL A1 = 1.25 to / or equal to 3.10 ----- CELL A2 = 2
etcetera....


--
darblooz

"etcetera" implies that you have more of these values, so it might be
better to set up a small table which lists the values and what you want
them to be tranformed into, and then you can use a VLOOKUP formula with
the final parameter set to TRUE.

Hope this helps.

Pete