| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Results into one cell
I am trying to put the results of 3 cells into one cell. Here's what I
am trying to do: e7 will equal either "" or 30, f7 will equal either"" or 36 and g7 will equal "" or 48. When any one of the cells has the appropiate number in it, 30, 36, or 48 the other two cells will be "".How do I write a formula for one cell that will have the result of 30, 36, or 48 in it based on the cells e7,f7 or g7? Thank you, |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Results into one cell
Maybe
=MAX(E7:G7) Mike "rudyeb" wrote: I am trying to put the results of 3 cells into one cell. Here's what I am trying to do: e7 will equal either "" or 30, f7 will equal either"" or 36 and g7 will equal "" or 48. When any one of the cells has the appropiate number in it, 30, 36, or 48 the other two cells will be "".How do I write a formula for one cell that will have the result of 30, 36, or 48 in it based on the cells e7,f7 or g7? Thank you, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Jump to cell based on cell results created by calendar control too | Excel Discussion (Misc queries) | |||
| Making a Cell turn color based on results in another cell | Excel Discussion (Misc queries) | |||
| Conditional Sum Argument results do not equal cell results Excel | Excel Worksheet Functions | |||
| Formatting one cell based on results of another cell | Excel Discussion (Misc queries) | |||
| Can multiple cell results be displayed in a single cell? | Excel Discussion (Misc queries) | |||
Linear Mode
