But in other case you just have to replace the old value (11) with the new value (12) in the required cell and rest excel handles it.
If you want to change the number from 11 to 12 in the formula, then you have to edit the hard code value 11 to 12 wherever required in the formula. The other way where we used =A1*A2 is called the formula using references. The formula =11*62 is called the hardcode formula, as you are hard coded 11 and 62 values in the formula. For example, if you want to multiply two numbers (11 & 62) in excel, you will either use =11*62 or input 11 in A1 cell and 62 in A2 cell and gets the multiplication in third cell with formula =A1*A2. Hard coding is a way of providing values in the formula. In this article, we will learn How and why to hardcode values in Excel.
