Display Formulas as Text Strings (1/20)


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

0

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 new list items for inclusion

Comments 0

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

Solve : Which Number is Smaller 0 or 6 ?

You are invited to the talkKs Reader Community

Join Now