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

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

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

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