Excel formula not available
Excel, which is useful for calculating data data on a computer, mainly uses functions to create calculation formulas. However, it can be difficult if the applied function or formula is not executed for some reason. If you don't specifically touch the program options, there will be no problem, but in case you don't know, let's see how to solve the problem of Excel not working.
Excel formula not available
First, this is a method of using the sum function as a method of summing the numbers of groups A~C. This is a method of calculating by entering from the designated start cell to the destination cell. Since it represents the sum, it is selected in the row and column direction.When calculating the sum of a specific square block designation, hold down the Shift key and select the upper left corner cell and the lower right cell to calculate the sum of the integrated cells. Will.
Excel formula not available
The following is a general symbol calculation method without using a function, but using a multiplier. First of all, the = mark is entered at the beginning of the calculation formula, and you can complete the calculation formula by adding (+) the positions of the cells to be summed as follows. This is the normal way to calculate Excel formulas.
Excel formula not available
If the calculation is not possible, it appears only in the form of a formula, and this is a method of changing the number so that it can be recognized. In the form of the formula below, the summed value is not shown, but can be shown as a formula. In this case, a single quotation mark is entered in front of the = in the formula to prevent the formula function from being executed. However, please note that these single quotes are not shown at the cell location, but are hidden, so you need to carefully check the function input section above to find them. In addition, when calculation is not possible due to the symptom of Excel formula not working, there is a way to solve it by changing the cell format to general or number, currency, or accounting format.
As an additional method, it is recommended to open the excel option window and check whether the calculation option of the formula tab is automatically selected as shown below. If this does not solve the problem, it is the case that an error has occurred in the program, so it is recommended to reinstall Excel.