Constants in Excel

 
Home
Excel Welcome
Spreadsheet Tutorial
Why on a Computer?
Basics of a Spreadsheet
COLUMN Defined
ROW Defined
CELL Defined
150Data Types
Labels in Excel
Constants in Excel
Formulas in Excel
Basic Formulas in Excel
Change in Formulas
Basic Math Functions
Methods of Selecting Cells
Sum Function
Average Function
Max Function
Min Function
Count Function
CountA Function
IF Function
PMT (loan stuff)
SIN COS TAN etc.
Function Wizard
Copying Formulas
Fill Down
Absolute Positioning
Fill Right
Formatting Text
I P Constants in Excel N


Constants are entries that have a specific fixed value. If someone asks you how old you are, you would answer with a specific answer. Sure, other people will have different answers, but it is a fixed value for each person.

In our first example: the constants were

  • $12,000
  • 9.6%
  • 60

 

As you can see from these examples there may be different types of numbers. Sometimes constants are referring to dollars, sometimes referring to percentages, and other times referring to a number of items (in this case 60 months).These are typed into the computer with just the numbers and are changed to display their type of number by formatting (we will talk about this later).
Again, we use constants to enter FIXED number data.

1493206


  info@exceltalk.net