formula with text values
I don't know how to do that without the = sign in a1 but this may work. In A1
type
'=3*50+1*120+2*25
You won't see the '
select A1 and
Data|text to columns
Fixed Width
Next
Next
In the destination box type $A$2
Click finish
Mike
"Combo" wrote:
Hi,
In cell A1 I have "3*50+1*120+2*25", with och without ", that doesn't matter
in this case. The value in A1 is for display for the user, so that the user
can see what values being summarized into cell A2.
Now, for the question. How can a write a formula that makes a SUM in cell A2
that uses the values in cell A1? If I put a = in cell A1 Excel will make the
calculation but if I want that value to show in cell A2?
Best regards,
/Combo
|