display a number in another cell

  • Thread starter Thread starter Motherlulu
  • Start date Start date
M

Motherlulu

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
 
Unless you just want to clear the other column, A bit of clarification is
needed.
 
.. 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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OMIT BLANK LINES WHEN FORCING A CARRIAGE RETURN --- PLEASE HELP! 5
Multiplying Empty Cells 6
Nested If/and statement 2
How do I nest these 3 IF functions? 4
Formula Check Please! 3
help with formula 3
Help: vlookup from multiple sheets and spreadhseets 1
sumproduct 4

Back
Top