Forum Discussion
rcatala3
Apr 20, 2022Copper Contributor
Subtraction
I want to subtract one cell from another. For example, E5 - E2.
I use the =SUM function but can't find one for subtraction.
Thanx in advance.
5 Replies
- Riny_van_EekelenPlatinum Contributor
- cjm44Copper Contributorwhat is the subtract y34 from e36
- Riny_van_EekelenPlatinum Contributor
=(E36-Y34)
- rcatala3Copper Contributor
Riny_van_Eekelen That was easy, duh. Thanx much
- mathetesSilver ContributorFor the record, you don't need SUM when adding two numbers either. =A1+B1 works just fine.
SUM becomes useful when you're summing a lot of numbers, as in SUM(A1:A125) or SUM(A1,B3,C5,D7) and that kind of construction never happens with subtraction.