Math Functions

Excel Addition Formula uses to add the values. It adds values in a column, individual cells etc. We can add values in excel without using any formula with “+” symbol as well. Formula: =SUM(number1, [number2], [number3]……) Explanation with Example Questions: After teaching the concept of AND Function to her children, Brenda decides to teach the … Read more

Subtraction in Excel might seem simple, but it holds the power to automate budgeting, accounting, and everyday calculations. While there is no dedicated SUBTRACT function like SUM, Excel handles subtraction using the minus symbol (-). Formula: =Value1 – Value2 Brenda’s Excel Lesson on Subtraction After teaching her children Carl and Carly the SUM function, Brenda … Read more

The average formula in excel calculates the average of given numbers. Average means the sum of numbers divided by the total numbers. Suppose there are 6 numbers, i.e., a,b,c,d,e,f then Average=(a+b+c+d+e+f)/6 To make the above calculation easy, we use the average formula in excel. Formula: =AVERAGE(number1, [number2],..) The above formula ignores all the empty cells … Read more

Excel’s multiply function is one of the most frequently used arithmetic tools in spreadsheets. It helps users quickly find totals, calculate costs, analyze performance metrics, and more. Whether you’re handling personal finance, sales data, or academic projects, multiplication in Excel is essential for accurate results. How to Multiply in Excel Excel doesn’t have a specific … Read more

As the name suggests, per cent means “per 100”. A percentage in Excel means a number that expresses as a fraction of 100. Formula= (Sum of marks obtained/ Total marks)*100 Explanation with Example Questions: Carly is very nervous on the way home as her result is not the way she expected. She doesn’t know how … Read more

There is no particular formula for the divide in excel. But we can use the divide symbol in excel, “/” for this purpose. Formula: number1/number2 Explanation with Example Questions: Today, Brenda decides to teach the division formula in excel to her children. She decides to bake a cake for her children and then teach them … Read more