| View previous topic :: View next topic |
| Author |
Message |
supradave
Newbie
Joined: 15 Sep 2010
Posts: 2
|
 Posted: Wed Sep 15, 2010 8:14 am Post subject: [SOLVED]Multiple values in a single cell |
 |
|
Basically, what I'm looking for is a way to put multiple values into a single cell.
For example, I have a column that I put my data into. I would like the max, mean and min and put them in one cell. Basically, cell A1 =max(c1:c10)"/"average(c1:c10)"/"min(c1:c10).
Yes, I could do that in columns.
Last edited by supradave on Wed Sep 15, 2010 11:56 am; edited 1 time in total |
|
| Back to top |
|
 |
Sliderule
Super User
Joined: 29 May 2004
Posts: 2474
Location: 3rd Rock From The Sun
|
| Posted: Wed Sep 15, 2010 10:03 am Post subject: |
|
|
| Code: | | = MAX(C1:C10) & "/" & AVERAGE(C1:C10) & "/" & MIN(C1:C10) |
Explanation: According to Calc Help for: operators;formula functions
| Calc Help: operators;formula functions wrote: |
Text operators
The operator combines separate texts into one text.
| Code: | Operator Name Example
& (And) text concatenation AND "Sun" & "day" is "Sunday" |
|
I hope this helps, please be sure to let me / us know.
Sliderule
Thanks to add [Solved] in your first post Title ( edit button ) if your issue has been fixed / resolved. |
|
| Back to top |
|
|
supradave
Newbie
Joined: 15 Sep 2010
Posts: 2
|
| Posted: Wed Sep 15, 2010 11:56 am Post subject: |
|
|
| Thanks for the help. |
|
| Back to top |
|
|
|
