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.
Comments 0