answersLogoWhite

0

=($A$1+B1) Putting a dollar sign, as shown on the left, turns the A1 cell into a constant value. Any value in the A1 cell will be unchanged no matter where the formula may be copied and pasted on the spreadsheet.

User Avatar

Wiki User

10y ago

Still curious? Ask our experts.

Chat with our AI personalities

ViviVivi
Your ride-or-die bestie who's seen you through every high and low.
Chat with Vivi
BeauBeau
You're doing better than you think!
Chat with Beau
JudyJudy
Simplicity is my specialty.
Chat with Judy

Add your answer:

Earn +20 pts
Q: What is a constant (spreadsheet)?
Write your answer...
Submit
Still have questions?
magnify glass
imp