Accounting Paper/Excel relating

Calculating the Median

In order to calculate the median of a group of values, use the formula “=MEDIAN(startcell,endcell”. For example, to calculate the median of cells A1 to A10, use the formula “=MEDIAN(A1:A10)”

Boolean function

The “=IF()” function can be used for checking whether particular conditions are fulfilled. For example, if we wanted to check if cell A1 has the value of 10, and if true, assign the value of 1, and if untrue, assign the value of 0, we can use the formula “=IF(A1=10,1,0)”. The first value in the brackets is the condition to check for, the second is the value to assign if true, and the third is the value to assign if untrue. This function can be used when determining whether a firm has above median or below median permanent earnings ratio.