Skip to content
Math and Formulas

THE BASICS

This chart presents the basic cell entries

Articles

Excel

Other

Basic Cell Entries

Number



Formula



Function Text

Enter in Cell


1234
1234
1234



=2+3
=A1+A2
=(A1+A2)*10



=SUM(A1:A10)
=COUNT(A1:A10)



The Cell Displays

1234
1,234
1,234.00

5
3
10

245
10

 
 

Basic Cell Entries                         Enter in Cell                                 The Cell Displays

Number    

 

Basic Cell Entries

Enter in Cell

The Cell Displays

Number

1234
1234
1234

1234
1,234
1,123.00

Formula

=2+3
=A1+A2
=(A1+A2)*10

5
3
30

Function

=SUM(A1:A10)
=COUNT(A1:A10)

245
10

Text

USA
Red
White
Blue

USA
Red
White
Blue

Note that the Numbers, Formulas and Functions are Right justified and the Text is Left justified which is the Excel default. This can be changed using the formatting tool in the ribbon.