Doh!

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Biff" wrote in message
...
Hi!

How about using MAX instead?

=MAX(A1,B5,C6)

Biff

"wjohnson" wrote
in
message ...

Can I use the LARGE Function with individual Cells or do they have to be
next to each other, (i.e A1:A6)?
Using the following I would like to have the value of B5 display in
Cell E5 using the LARGE Function.
Cell A1=10
Cell B5=20
Cell C6=15


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile:
http://www.excelforum.com/member.php...o&userid=29640
View this thread:
http://www.excelforum.com/showthread...hreadid=516016