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