More than one formula in a cell??

[Guest]

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?

 

[Guest]

Try

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

 

[Guest]

Thanks!! This board sure is a help and a time saver! I'm thankful for those
that take the time to respond.

 

[Bob Phillips]

or even

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

<g>


--

HTH

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