Combining text from cells to a formula

  • Thread starter Thread starter Svein Olav Steinmo
  • Start date Start date
S

Svein Olav Steinmo

Im trying to do the following:

AB1 = 30
AB2 = 2

A1 = "$AB$1"
B1 = "$AB$2"

In C1 I want to get a formula that says =A1*B1
And I want the result displayed in C1 to be 60

I have tried to set C1 to: = "="&A1&"*"&B1

C1 then returns the text '=A1*B1', not the result of that formula. How can I
do this ???

Best regards
Svein Olav Steinmo
 
You can't perform math functions on text. It's not clear
why A1 and B1 are set to text instead of referencing the
values in AB1 and AB2.

Can you do one of the following? Either set A1 and B1 to
=$AB$1 and =$AB$2 without the quotes, then enter =A1*B1 in
C1...

OR

Leave A1 and B1 to display the text, then use the formula
=AB1*AB2 in C1.

Please disregard if I misunderstood your original
intention.
 
Back
Top