Archive List for August 2017

Calculate the average (conditions, 0 and spaces)/AVERAGE functions

Basic Course

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・・・

Conditional formulas used in functions such as the IF

Basic Course

  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・・・

To the top