View Single Post
  #1   Report Post  
Shirley
 
Posts: n/a
Default More than one formula in a cell??

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