Excel also lets you combine direct numbers and cell references in the same formula. For example, if you want to add 50 to the value in cell C1 , your formula would look like this: =C1+50 .

After adding apostrophes, Excel has displayed the original value without rounding. Read : How to create a Thermometer Chart in Excel . 2] How to prevent Excel from rounding decimal numbers ...

To add a zero after a number in Excel, you can use the CONCATENATE function. For that, you need to choose a cell and enter this formula: =CONCATENATE(A1, “000”).

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.