How do I create a viewable formula using calculated fields?)Excel

[JohnH]

I need to build a fileld in an Excel Spreadsheet which shows 2 other
calculates field values in a simple statement. (ie: A1 = X1 + Y2 and B1 = R4
/ V20 such that the computed value of A1 may = 350 and B1 may = 450... I
want to show in another cell, such as C1 the computed values in a formula
ie: C1 = "(350 / 450)" will be visable, not treated as a formula and
computed. I hope this is somewhat clear.

[Jeff Stevens]

The following fomula should work for you:

=TEXT(A1,0)&"/"&TEXT(B1,0)


"JohnH" <JohnH@discussions.microsoft.com> wrote in message
news:7B4BAE47-DE2F-45A7-B694-7DD7A4584A94@microsoft.com...
> I need to build a fileld in an Excel Spreadsheet which shows 2 other
> calculates field values in a simple statement. (ie: A1 = X1 + Y2 and B1 =
R4
> / V20 such that the computed value of A1 may = 350 and B1 may = 450... I
> want to show in another cell, such as C1 the computed values in a formula
> ie: C1 = "(350 / 450)" will be visable, not treated as a formula and
> computed. I hope this is somewhat clear.

[Gord Dibben]

John

One method.........

="("&A1&"/"&B1&")" returns (350/450)


Gord Dibben Excel MVP




On Mon, 5 Dec 2005 22:19:02 -0800, "JohnH" <JohnH@discussions.microsoft.com>
wrote:

>I need to build a fileld in an Excel Spreadsheet which shows 2 other
>calculates field values in a simple statement. (ie: A1 = X1 + Y2 and B1 = R4
>/ V20 such that the computed value of A1 may = 350 and B1 may = 450... I
>want to show in another cell, such as C1 the computed values in a formula
>ie: C1 = "(350 / 450)" will be visable, not treated as a formula and
>computed. I hope this is somewhat clear.

[David McRitchie]

The intent is to show the formula actually in use in another cell, install
GetFormula in your personal.xls workbook
and invoke as follows:
=personal.xls!GetFormula(A1)

see page http://www.mvps.org/dmcritchie/excel/formula.htm

This will show the formula as you see it on the formula bar.

If the intent was to convert each address in a formula to a constant
and show it that way his is not the solution.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

[JohnH]

Thanks Jeff, The formula portion works fine but I also needed the "(" and
")" around the numbers. The Gord Dibben solution appears to work well also.

"Jeff Stevens" wrote:

> The following fomula should work for you:
>
> =TEXT(A1,0)&"/"&TEXT(B1,0)
>
>
> "JohnH" <JohnH@discussions.microsoft.com> wrote in message
> news:7B4BAE47-DE2F-45A7-B694-7DD7A4584A94@microsoft.com...
> > I need to build a fileld in an Excel Spreadsheet which shows 2 other
> > calculates field values in a simple statement. (ie: A1 = X1 + Y2 and B1 =
> R4
> > / V20 such that the computed value of A1 may = 350 and B1 may = 450... I
> > want to show in another cell, such as C1 the computed values in a formula
> > ie: C1 = "(350 / 450)" will be visable, not treated as a formula and
> > computed. I hope this is somewhat clear.
>
>
>