ExcelBanter - how do I keep a box as a constant in all of my calculations?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how do I keep a box as a constant in all of my calculations? (https://www.excelbanter.com/excel-worksheet-functions/6655-how-do-i-keep-box-constant-all-my-calculations.html)

Liz

how do I keep a box as a constant in all of my calculations?

When I am doing a calculation, how do I keep a box constant? I know you
place some symbol in front and behind it, but I just don't remember which.

Frank Kabel

Hi
do you mean for axample
$A$1
(absolute reference vs. relative reference)

"Liz" wrote:

When I am doing a calculation, how do I keep a box constant? I know you
place some symbol in front and behind it, but I just don't remember which.

All times are GMT +1. The time now is 07:21 PM.