Display largest of 3 numbers into 4rth cell

J

JcR

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
 
P

Pivotrend

=LARGE(A1:A3,1) would give FIRST highest digit
=LARGE(A1:A3,2) would give SECOND highest digit
=LARGE(A1:A3,3) would give THIRD highest digit

=SMALL would give the opposite
 
Top