Calculate the average/mean (AVERAGE function) To calculate the average/mean for data in Excel, we use the AVERAGE function. =AVERAGE(number1, [number2]…) [number1] = Identify the 1st number or cell range to calculate the average for. [number2] = Not obligatory. Identify when there is a number or cell range other than [number1]. Definition of function A function to・・・

# Archive List for August 2017

## Conditional formulas used in functions such as the IF

Greater/smaller than or equal to~, greater/smaller than~, equal to~ When using the IF function, we sometimes want to include complicated conditions such as ‘greater than…‘ or ‘smaller than or equal to…’. Let us see how we can define these conditions correctly in the formula. Example of use) How to use the comparison operator・・・