Display Formulas as Text Strings (20/20)


Display Google Sheets Formulas as Text Strings
Display Google Sheets Formulas as Text Strings

-1

Sometimes, you might want to display a formula on a cell to explain the calculations you have made on another cell. But once you enter this formula on a cell, Google Sheets will automatically run it as an actual formula.
To avoid this processing, you can insert an apostrophe before typing the formula. This will display your formula as a text string.


talkKs editorial
Use the comment section to suggest things we might have missed.

Comments 0

Your email address will not be published. Required fields are marked *

Solve : Which Number is Smaller 7 or 6 ?