#VALUE!

G

Gus

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
 
D

davesexcel

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
 
D

Dave Peterson

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
 
G

Gus

Hi Dave,

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