Subtracting cell contents - I can't believe it's not working!

G

Guest

I have a cell with generated data (L45) with this formula in it:
=SUM(L43+L44) and another cell that I manually enter an amopunt (M47). I want
to simply subtract the contents of one cell from another.
What is the formula? I tried:
=M47-L45
=sum(m47-l45)
=sum(m47)-(l45)
And all of them end up equalling 0
I can't believe it's not working and was hoping someone can help?
Thanks,
drumz
 
G

Guest

why do you use sum(L43+44),you only need =L43+L44 or sum(L43:L44)
your new formula is in say m48 =L45-M47
 

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

Array Formula for a Finite Series Sum ?? 3
excel 2003 (11.8307.8221) SP3 - custom cell formatting question 2
How do I refer to the results of a function in a cell not the form 2
adding multiple cell contents 2
treat cell contents as reference not value? 3
If it's not a space, return the cell contents. 3
How do I convert a cell(s) from the formula to it's contents? 9
Adding contents of one cell to a range of cells. 1

Top