Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Subtracting cell contents - I can't believe it's not working!
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 |
#2
|
|||
|
|||
Nevermind, I messed up!
"drumz" wrote: 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 |
#3
|
|||
|
|||
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 -- paul remove nospam for email addy! "drumz" wrote: Nevermind, I messed up! "drumz" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell color index comparison | New Users to Excel | |||
Function syntax to compare cell contents | Excel Worksheet Functions | |||
How do I find the contents of a cell using the "ADDRESS" function. | Excel Worksheet Functions | |||
Formula to return cell contents based on multiple conditions | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |