Is there a function to display the text version of a calculation?

Created at: 2021-05-07 07:30:13
Questioner General

It would be handy to see the text version of some what if calculations.



For example, if the cell is "=3*(14*17+50)" I want the next column to display "3*(14*17+50)".



I thought the function "T" would do it, but it doesn't. There is no "TEXT" function in Numbers.



I tried doing the other way around, making the calculation a text cell, and then calculating that, but the function VALUE didn't do what I expected.



Answer #1:

By: Ms. Casandra Wiza

It would be handy to see the text version of some what if calculations.



For example, if the cell is "=3*(14*17+50)" I want the next column to display "3*(14*17+50)".



I thought the function "T" would do it, but it doesn't. There is no "TEXT" function in Numbers.



I tried doing the other way around, making the calculation a text cell, and then calculating that, but the function VALUE didn't do what I expected.



Answer #2:

By: Jacques Torphy

Perhaps the function FORMULATEXT() will do what you want.







SG

Answer #3:

By: Citlalli Luettgen

Do these show what you want to do:



Convert choice produces this result in selected cell (A2) Cell in column B contains a copy f the formula, and displays the result.

Noe that numbers automatic substitution of the multiplication sign for the multiplication operator ( * ) is not reversed in the conversion.



I entered the formula in both cells, then opened the Formula editor in A2, and did the conversion .



Regards,

Barry

Answer #4:

By: Dr. Seth Shanahan DDS

SG writes: Perhaps the function FORMULATEXT() will do what you want.



Recent addition?



Barry

Answer #5:

By: Dr. Tiara Abbott

Do these show what you want to do:



Convert choice produces this result in selected cell (A2) Cell in column B contains a copy f the formula, and displays the result.

Noe that numbers automatic substitution of the multiplication sign for the multiplication operator ( * ) is not reversed in the conversion.



I entered the formula in both cells, then opened the Formula editor in A2, and did the conversion .



Regards,

Barry

Answer #6:

By: Willy Rodriguez Jr.

Perhaps the function FORMULATEXT() will do what you want.







SG

Answer #7:

By: Amy Gottlieb

SG writes: Perhaps the function FORMULATEXT() will do what you want.



Recent addition?



Barry

Answer #8:

By: Esta Ritchie DVM

Yes, FORMULATEXT() does exactly what I need. Oddly, it does not show up in the alphabetic list of functions under Text or Numeric or Financial or Engineering or the others. Searching for the function name gives a link to a list of functions - where FORMULATEXT is not listed. I'll just have to remember the name.

Answer #9:

By: Sienna Turcotte

Useful, and it looks like for function FORMULATEXT() does exactly what I wanted.

Answer #10:

By: Silas Haag

It doesn't seem to be well documented.



Even these other new functions don't seem to be on the main list.



You might want to give feedback to Apple via Numbers > Provide Numbers Feedback in your menu.



SG