is this possible?

[new2vba]

i have two columns:
=F2-B2
=E2-B2

i want another column that shows the values of both columns such as:

=F2-B2 (= "0")
=E2-B2 (= "1")

new column: "0 to 1"

 

[patrickmuldoon99]

I read, I read again, and yet still I have no idea what you want.

 

[onlyadrafter]

Hello,

Do you mean

=H2 &" to " &I2

where H2 = F2-B2 and
where I2 = E2-B2

 

[new2vba]

Hello,

Do you mean

=H2 &" to " &I2

where H2 = F2-B2 and
where I2 = E2-B2

EXACTLY
thanks!

 

[new2vba]

Hello,

Do you mean

=H2 &" to " &I2

where H2 = F2-B2 and
where I2 = E2-B2

oad,
this works great except i am getting about 20 decimal places on some....know how to limit it to just two?

ex:

Book2
	K	L	M	N
2	-1	0	-1to0
3	-1	0	-1to0
4	-1	0	-1to0
5	-1.16	-0.66	-1.16to-0.659999999999997
6	-2	-1	-2to-1
7	-0.67	-0.17	-0.670000000000002to-0.170000000000002
8	-1.34	-0.34	-1.34to-0.340000000000003
9	-1.4	-0.4	-1.4to-0.399999999999999
10	-1.81	-0.81	-1.81to-0.810000000000002
11	-1	0	-1to0
12	-0.83	-0.33	-0.830000000000005to-0.330000000000005
13	-50.08	-50.08	-50.08to-50.08
14	-0.66	-0.16	-0.659999999999997to-0.159999999999997
Sheet1

 

[new2vba]

why would excel do this?

why would excel decide to tack on 15 decimal places to some cell contents?

 

[Kjuel]

Try

=TEXT(H2;"0,00") & " to " & TEXT(I2;"0,00")

The formatting works like Custom Number under the menu Format Cell.

 

[new2vba]

Try

=TEXT(H2;"0,00") & " to " & TEXT(I2;"0,00")

The formatting works like Custom Number under the menu Format Cell.

this says formula contains an error and highlights the "h2"

 

[new2vba]

this:
=TEXT(K2,"0,00") & " to " & TEXT(L2,"0,00")

is getting close but turns:

-1.00 0.00

into:

-001 to 000

 

[Norie]

Change the semi-colon : to a comma ,.

Kjuel appears to be in Denmark where the ; seperator is used in formulas rather than a comma.

Also change the comma in "0,00" to a . , again an international settings issue.