Looking at other column, upping value

Mar 12th, 2002, 02:04 PM

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 · Mar 12th, 2002, 02:09 PM

Somthing like this perhaps:

=LEFT(a1,3)+0

where with 9.1x, x is trimmed?

Cheers, Nate

NateO · Mar 12th, 2002, 02:13 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 12th, 2002, 02:04 PM	#1
Guest Posts: n/a	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?

Mar 12th, 2002, 02:09 PM	#2
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	Somthing like this perhaps: =LEFT(a1,3)+0 where with 9.1x, x is trimmed? Cheers, Nate

Mar 12th, 2002, 02:13 PM	#3
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	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