| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula and text in one cell?
I have a formula that SUMS the rows above it but also want to show the
overall percent. Can I do a SUM and text and another SUM in one cell without additional hidden cells? Something like this? =SUM(J5:J20) & "Text here" & SUM((J:20+K:20+L:20)/3) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| bold text of referenced cell show in formula cell | Excel Worksheet Functions | |||
| The result of a formula referring to a cell with formula as text? | Excel Worksheet Functions | |||
| linking a text formatted cell to a formula cell | Excel Discussion (Misc queries) | |||
| Concatenate text cell and formula cell result | Excel Worksheet Functions | |||
| match cell text with text in formula | Excel Worksheet Functions | |||
Threaded Mode
