Looking at other column, upping value

[Guest]

This is an example:
A
9.13
9.14
9.19
9.21
9.25
9.28

I want the Value in Column B to adjust so that it gives the same result for everything beginning with 9.1, then .01 higher for everything with 9.2, etc.

Can anyone help?

 

[NateO]

Somthing like this perhaps:

=LEFT(a1,3)+0

where with 9.1x, x is trimmed?

Cheers, Nate

 

[NateO]

Or did you mean every 9.1x returns 9.11 and every 9.2x returns 9.22...If so, try:

=(LEFT(F12,3)+0&MID(F12,3,1))+0

Hope that helps,

Cheers,

Nate