Combining Text Value with Numbers and evaluating

**obrien234** · 07-01-2008, 03:35 PM

I have two separate cells. One is a number, for example cell B1 with a value
of 0.109. The other, B2, is in the format "* A1". I'm trying to combine the
two cells so they will display the value of "0.109 * A1", where A1 is a
reference to the cell A1. I've copied these cells from another program and
Excel does not seem to recognize that the text "* A1" works in a formula.
I've tried using a formula like

B1&B2
or
B1+B2

but the formatting is not correct and excel just displays the function
without evaluating it to the number it should represent. Any suggestions?

thank you

**NBVC** · 07-01-2008, 03:56 PM

Here's one way.. that'll work if you are putting result in the adjacent cell to the input values...

Select the cell you want the result to go in (B3) and then go to Insert|Name|Define and enter name: Evaluation

In the Refers to field enter formula: =EVALUATE(Sheet1!$B1&Sheet1!$B2)

where B1 and B2 are your 2 input cells (and B3 is where you are going to have a result)

Click Ok

Now in B3, enter formula =Evaluation

**obrien234** · 07-02-2008, 10:03 AM

You have made my life so much easier. It worked like a charm. Thank you so much.

**obrien234** · 07-02-2008, 11:40 AM

I got the Evaluation thing working great, but I have one last request.

The values from the =Evaluation cells do not auto-update (i.e. if I change the value of A2, the cells don't register that and readjust). Is there anyway I can have the =evaluation cells auto-update or a macro that I can make to cause these to update.

Thank you so much.