Pick highest cell number between 5 cells for Excel 97 1

[K6lmd]

In Excel spreedsheet,
I have 5 cells(a1-a5) containing various numbers, In the A6 cell, I want to pick the highest number from cells 1-5. In the A7 cell, I want to pick lowest number between cells 1-5.
Any suggestions on this formula would be appreciated.

 

[svanels]

=max(a1:a5)
and =min(a1:a:5) S. van Els
SAvanEls@cq-link.sr

 

[K6lmd]

Thanks, it worked great.

 

[Dennis2]

You may just want to highlight the cells in question and then right click on the 'Status' bar (right below the 'Sheet1, Sheet2, Sheet3). When you look on the right half, you'll see the results of your selection. You may choose to see any of the following choices: 'Average', 'Count', Count Nums', 'Max', 'Min', or 'Sum'.

This is much easier than using any 'Paste' functions or remembering any 'expressions'.