how to pass to many values as inputs for the one cell

[ramsvlsi]

hi friends,


i implemented a algorithm that converts decimal fractions to binary fractions. In general we can enter only one value to input cell. but i want to pass bulk values to the input cell. and every output should display in column

ex:
"C1" is the input cell, "H5" is the output cell
i entered input values in a column like "B13","B14","B15"......."B19"
and each output display in second column like "C13","C14","C15"......"C19"

all these inputs passed to "C1"cell and output values back to above mentioned cells
iam attaching simple example file with input samples please tell me how to get outputs.

thank u

[JBeaucaire]

Let me get this straight...you want to enter a value into cell C1 and have the binary version of that value appear in the listing below C12?

How about each time you enter a value in C1, that value is transferred to the next empty cell below C12, and it matching binary value from H5 appears next to it in the Outputs column? Would that work for you?

[JBeaucaire]

Here's the code I inserted into the sheet itself:

Please Login or Register  to view this content.

Start entering values in C1, see if this works for you.

[ramsvlsi]

good work thank u, but i don't want to enter all the hundreds of values. for inputs i use drag option to auto increment, corresponding outputs automatically copied to previously mentioned cells.

i don't know how to code but i will explain like "c" language

for(i=13;i<=X;i++)
{
"C1" = "Bi"; // copy input value to C1
"Ci" = "H5"; // print output Value to C13,C14........CX
}

x => end of the inputs cell number.
i=13 => because in the given excel sheet starting of input cell is "B13"
B13 => first input cell
C13 => first output cell


i don't know this type of operations is allowed or not .please give me the equivalent operation.

thanking u

[JBeaucaire]

I'm confused by all the hoops. If you're just trying to get a list of binary numbers from an incremental list, you can do that with no code in about 30 seconds.

Put a 1 in A1 and a 2 an A2, the drag that down a few hundred rows, you'll get a list of "input" values.

Next to A1 in B1 put your formula from H5 but have it evaluate cell A1:
=DEC2BIN(A1,5)

Now copy that down the same distance. Done.

Although it appears to only go up 31 anyway before your formula runs out of room.

[ramsvlsi]

please understand my problem,

u replied a excel sheet with some equations. i need in that way only,
but i don't want to enter all my inputs in the formula itself, rather i enter all the inputs at somewhere ,

those inputs will pass one by one to the inputs of the formula and each output one by one goto the another cell like how u did in ur excel.


thanking you

[ramsvlsi]

here iam attaching my real values please tell me how to do it.

sheet1 having input values
in sheet2 i developed a formula to convert floating to binary converter.

i specified inputs and outputs of the formula clearly in sheet1 also.

[JBeaucaire]

Sorry, I got nothing. This is way over my head, or it's just too late at night, I cannot get my head around what your sheet is doing, much less what you really want us to help with.