Convert formula to text?

  • Thread starter Thread starter Dave85
  • Start date Start date
D

Dave85

Hi, I have two questions regarding the formula of Excel:

1) When I make a formula appears, i.e. =A2/B2, and the header of A2 is
"Mass", and header of B2 is "Volume", is there a way I can make the
formula appear as "=Mass/Volume"?

2) Like the above example, but if the value in A2 was 10, the value in
B2 was 5, can I make the formula appear as =10/5 ?

Thank you very much
 
1) You can if your formula resides in the same row as your values.
Choose Tools/Options/Calculation and check the Accept labels in
formulas checkbox. Then, with

A1: Mass
B1: Volume
A2: 10
B2: 5

enter

C2: =Mass / Volume ===> 2

See "About labels and names in formulas" in XL Help

2) No.
 
Dave,

1) Generally, you make your header the way you want it. Type '=Mass/Volume.
The apostrophe causes Excel to interpret it as text, not try to act on it as
a formula.

2) = "=" & A2 & "/" & B2
 
Thank you all for replying. But, there is a misunderstanding between
us:

1) The reason why I want to have the formula as "Mass/Volume" is
because I have to present it in words on paper. If the header is too
long, then it would be hell to type them in. I still use the cell
reference to create formulas because it is faster that way, but I need
the formula to somehow appear in term of headers.

2)Earl, your method is great, but how do you do this =B7*(B3/1000) ?

Thank you
 
Back
Top