I am having an issue finding a formula and wondered whether it actually exists...

If I have a number of cells each with a value, can Excel place the cell with the highest value in the total cell?

For example
A1 = 4
A2 = 1
A3 = 1
A4 = 3
A5 = 4
A6 = 2
I would want the formula cell to let me know that the highest number within all the cells (A1 to A6) is 4 and therefore place a 4 in that cell.

Hope this makes sense and thank you in advance for your help