or even

=MAX(A1:A5,1)&"\"&MIN(A1:A5,5)

<g


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Barb R." wrote in message
...
Try

=MIN(A1:A5)&" / "&MAX(A1:A5)

"Shirley" wrote:

Can you enter more than one formula in a single cell? What I mean is, I
want
to list two values in a cell. For example, if I have the following
data:
100
200
300
400
500
and I want the cell to display the highest and lowest values like: 500
\ 100
can I somehow enter LARGE(A1:A5,1) &"\" LARGE(A1:A5,5)
or do I have to use two cells?


--
Shirley