1. ## Populate Column with Answers

I want to populate column E (Answer) with the results of multiplying column C (Factor) by column D (Input), rows 5-16, as per attached file.

Column D now shows a 10 at row 8 so the 10 should be multiplied by each factor of column C and the answers should be shown in column E. Then when I input another number anywhere in column D that number should again be multiplied by each factor from column C. There is no need to save the results in column E

The formula shown on the same sheet which for some unexplained reason when I write it on the VB Editor does not stay there after I exit the file although I save it. This formula I found it on the web but it does not work, perhaps Im missing something?

Thank you  Reply With Quote

2. I found a way but don’t know if it’s the best

In column E write the formula =C5*\$D\$5 and copy it down to row 16, plus merge the cells in column D so there is only one row in the range  Reply With Quote

3. I am not sure I completely understand your request ,just wrote formula as follow by guessing.

Assume you will only enter one numerical number in D5 16

E5=C5&MAX(\$D\$5:\$D\$16)  Reply With Quote

4. Originally Posted by caabyyc I am not sure I completely understand your request ,just wrote formula as follow by guessing.

Assume you will only enter one numerical number in D5 16

E5=C5&MAX(\$D\$5:\$D\$16)
Thank you caabyyc for the help

I just realized my #2 post is wrong and does not give me what I want. Basically what I have is a units converter, in column D I find the row of the unit I want to convert, lets say 10 feet, so I insert 10 in row 6 and I should get the equivalent of 10 feet to all other units

Yes at D5:16 is only numbers

Where do I insert your formula?  Reply With Quote

5. If you put the number in E1 & the original Unit in F1, you can use this in E5 copied down
=CONVERT(\$E\$1,\$F\$1,B5)  Reply With Quote

6. Originally Posted by Fluff If you put the number in E1 & the original Unit in F1, you can use this in E5 copied down
=CONVERT(\$E\$1,\$F\$1,B5)

You might be into something good here Fluff

When you say the “number in E1” I assume you mean the Input. I did that and all the rest but I get on E5, #N/A.

Can you explain how this formula should work?

Thank you  Reply With Quote

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•