Display largest of 3 numbers into 4rth cell
 

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

Display largest of 3 numbers into 4rth cell
 

=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

Display largest of 3 numbers into 4rth cell
 

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

Display largest of 3 numbers into 4rth cell
 

=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


--
Pivotrend
------------------------------------------------------------------------
Pivotrend's Profile: http://www.excelforum.com/member.php...fo&userid=4062
View this thread: http://www.excelforum.com/showthread...hreadid=521549

Display largest of 3 numbers into 4rth cell
 

thanks

"Pivotrend" wrote:


=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


--
Pivotrend
------------------------------------------------------------------------
Pivotrend's Profile: http://www.excelforum.com/member.php...fo&userid=4062
View this thread: http://www.excelforum.com/showthread...hreadid=521549

Display largest of 3 numbers into 4rth cell
 

thanks

"Niek Otten" wrote:

=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