How to calculate the average output using the AVERAGE function
In this example, the output of three production lines has been recorded for several days. Now the average of the three highest outputs of each line has to be calculated. For this task, Excel provides the AVERAGE function, which returns the average, or arithmetic mean, of the arguments. Here is the syntax that is used:
AVERAGE(number1, [...]
How to Use the MAX function to find the largest value in a range
This example finds the largest value in the range A3:D11 by using the MAX function. The function’s return value is the largest value in a set. Here is the syntax for using the MAX Function
MAX(number1, number2, …)
number1, number2, …: From 1 to 30 numbers for which you want to find the largest value. It is [...]
How to use SUMIF to add values higher than a certain amount
This is yet another SUMIF function Example. This time we are going to use it to add only the values that are above a certain amount. For this example, we are going to add values above $500. This formula will add the cells that are specified by a given criteria. Here is how we will [...]
Combine Cells with text, date, time and numbers in Excel
For this example, we are going to combine text and numbers from two different cells into one cell. To achieve this, we will need to use the & Operator. This will basically combine the different cell values that we will be working with. Here is how to do it.
How to combine text and numbers in [...]
Calculate a person’s age in days using Excel
A worksheet lists Names in column A and their birth dates in column B. To calculate the age of these persons in days, first, enter the current date in cell B1 and then perform the following steps:
How to Calculate the age of a person in days:
Open a worksheet in Excel
In this example, we are assuming [...]
