Hi there,

i'm trying to solve probably a very simple problem, but can't find the
answer. here's what i get:


B C
113.00
112.75 -0.00221 =b2/b1-1
107.00 #VALUE! =b3/b2-1
107.00 #VALUE! =b4/b3-1
113.00 #VALUE! = b5/b4-1

can anyone help me, pls? thanks

113
112.75 =A2/A1-1
107 =A3/A2-1
107 =A4/A3-1
113 =A5/A4-1

113
112.75 -0.002212389
107 -0.050997783
107 0
113 0.056074766


I don't get that problem


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=519002

Hi Dave,

Thanks, but the problem happens when i drag down the formula. Any
guesses as to why? Cheers

Where did you get the data? If you got it from a web page, there might be other
stuff in that cell (I'm guessing some of those HTML non-breaking spaces???)

Try retyping the values into the cells.

If you have way too many to do this manually, you may want to try David
McRitchie's routine to clean the data:

http://www.mvps.org/dmcritchie/excel/join.htm#trimall
(look for "Sub Trimall()")

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Gus wrote:

Hi there,

i'm trying to solve probably a very simple problem, but can't find the
answer. here's what i get:

B C
113.00
112.75 -0.00221 =b2/b1-1
107.00 #VALUE! =b3/b2-1
107.00 #VALUE! =b4/b3-1
113.00 #VALUE! = b5/b4-1

can anyone help me, pls? thanks

--

Dave Peterson

Thanks, Dave. I re-typed and it workd fine..Cheers