In A4

--
Kind regards,

Niek Otten

"Niek Otten" wrote in message ...
=MAX(A1:A3)

--
Kind regards,

Niek Otten

"JcR" wrote in message ...
cell a1 = 5
cell a2 = 4
cell a3 = 6

What is formula to so that that largest value in cells a1, a2, a3 apprears
in cell a4 ?

In this case "6" would be the answer and formula would make "6" appear in
cell a4