| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
display a number in another cell
Hello,
I would like the number that is displayed in row M15:L15 to display in row M15. Only one cell would have a number in it. Thanks for your help |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
display a number in another cell
Unless you just want to clear the other column, A bit of clarification is
needed. -- Don Guillett Microsoft MVP Excel SalesAid Software "Motherlulu" wrote in message . .. Hello, I would like the number that is displayed in row M15:L15 to display in row M15. Only one cell would have a number in it. Thanks for your help |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
display a number in another cell
.. i don't uderstand what you want: you cannot put a formula in M15 which
references M15. Do you mean M15:L15 or A15:L15? =MAX(A15:L15) would work if there is only one cell with a number. "Motherlulu" wrote: Hello, I would like the number that is displayed in row M15:L15 to display in row M15. Only one cell would have a number in it. Thanks for your help |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
display a number in another cell
M15 can't be both the output cell of your formula and one of your input
cells. If your input is in only one cell of the range A15:L15, then you can put =SUM(A15:L15) into M15. -- David Biddulph "Motherlulu" wrote in message . .. Hello, I would like the number that is displayed in row M15:L15 to display in row M15. Only one cell would have a number in it. Thanks for your help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| display text in one cell as a number in an adjacent cell in excel | New Users to Excel | |||
| have one cell display text which reflects a number in another cell | Excel Discussion (Misc queries) | |||
| a cell to display number of days in a month given in another cell | Excel Worksheet Functions | |||
| Display row & column number in cell | Excel Worksheet Functions | |||
| I want to display the number 0 first in a cell, it won't let me n. | Excel Discussion (Misc queries) | |||
Linear Mode
