answersLogoWhite

0

What are constants for in Excel?

Updated: 10/27/2022
User Avatar

Wiki User

8y ago

Best Answer

Constants are fixed values, so they never change. They are used in formulas where you know a particular value does not change. If you have a formula that is always going to multiply something by 2, then the 2 is a fixed value and can be entered into the formula as a constant, while the other value will be a cell reference, so it can have a variable value, like in the following formula.

=H5 * 2

User Avatar

Wiki User

8y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What are constants for in Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Can text constants be in Excel formulas?

Yes they can be. Certain kinds of formulas will have text constants in them. The text must be enclosed in quotations marks so it is treated as text and not as a name that can be applied to a cell or cell ranges.


How many constants are there in the word python?

There are 4 constants.


What are constants and how are they are different from variables?

Variables change, constants do not.


Explain different types of constant?

Integer constants Character constants Real/floating point constants String constants


Coding constants in c?

Coding constants in c means writing the constants in a certain way that the c language understands.


Why constants have fixed value?

It's arbitrary. That's the way that constants are defined.


No of independent elastic constants required for isotropic material?

Two independent elastic constants


What are universal economic constants?

The Universal Economic Constants are Production, Investment, Savings and Consumption.


How many different types of constants are there in COBOL?

there are three types of constants in COBOL 1. numeric literals 2. figurative constants 3. non-numeric literals


Why do constant constants have units?

Constants in the sense you mean are different to mathematical constants. They usually refer to a system in which two values are proportionate and so are of the units associated with the system.


What is the study of constants?

There is no specific name for such an activity. Besides, constants appear in different fields of study.


What constants can be added to x2 - x to form a perfect square trinomial?

There are no FOLLOWING constants! The answer is 0.25