Yvette has attended:
Excel Advanced course
Excel Formulas
1) What is the formula entry to get and average of a column of figures
2) What is the formula entry to get the highest number to appear from a column of figures
3) What is the formula entry to get the lowest number to appear from a column of figures
Thanks in advance
RE: Excel Formulas
Hi Yvette,
In response to yur query,
In each example, first place your cursor where you want the result of your calculation to be displayed.
1) The formula to get the Average of a column of figures is =AVERAGE(A1:A10)
Where A1: A10 represents a column of cells containing the figures that an average is required for.
2) The formula to get the Highest number in a column of figures is =MAX(A1:A10)
Where A1: A10 represents acolumn of cells containing the figures that highest is required for.
3) The formula to get the Lowest number in a column of figures is =MIN(A1:A10)
Where A1: A10 represents a column of cells containing the figures that lowest is required for.
Hope this helps
