SUM, COUNT, COUNTA, COUNTBLANK, AVERAGE, MIN Excel, MAX Excel, LEN Excel, TRIM Excel, IF Excel are the top ten excel formulas and functions. In this article, we will explain to you the importance of the “dollar ($)” symbol in basic excel formula Basic Excel Formula The term "basic excel formula" refers to the general functions used in Microsoft Excel to do simple calculations such as addition, average, and comparison. I was not different from you either I had the same doubt. One of the common questions among all the excel beginners is, “what does the dollar ($) symbol doing inside formula”? This is the most trending question in excel forums.
$ Symbol in excel is used to lock a specific cell or rows or columns in a worksheet, the shortcut to lock down a reference in excel is by pressing ALT + F4, this feature is used while working in formulas when we do not want the reference to be changed when we copy or drag down the formula to other cell references, this feature will keep the reference same for all the further calculations.
0 kommentar(er)
