answersLogoWhite

0

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

9y ago

Still curious? Ask our experts.

Chat with our AI personalities

SteveSteve
Knowledge is a journey, you know? We'll get there.
Chat with Steve
CoachCoach
Success isn't just about winning—it's about vision, patience, and playing the long game.
Chat with Coach
JordanJordan
Looking for a career mentor? I've seen my fair share of shake-ups.
Chat with Jordan

Add your answer:

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