More than one formula in a cell??

S

Shirley

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?
 
S

swatsp0p

A slight correction will make it work:

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

note the addition of the '&' after the "\" as well as in front of it.

Good Luck

Bruc
 
S

Shirley

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

Bob Phillips

or even

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

<g>


--

HTH

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