How To Keep A Number Constant In Excel SpreadCheaters
How To Keep A Number Constant In Excel Formula. Web for example, if you have a formula =a1*b1 and you want to keep cell a1 constant, you would change it to =$a$1*b1. Just put the $ sign in front of your desired constant cell.
Just put the $ sign in front of your desired constant cell. Like $a6 if you wish to just change the number 6. Web for example, if you have a formula =a1*b1 and you want to keep cell a1 constant, you would change it to =$a$1*b1.
Like $a6 if you wish to just change the number 6. Just put the $ sign in front of your desired constant cell. Like $a6 if you wish to just change the number 6. Web for example, if you have a formula =a1*b1 and you want to keep cell a1 constant, you would change it to =$a$1*b1.
