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.
- Apr 20, 2022
Riny_van_Eekelen
Apr 20, 2022Platinum Contributor
rcatala3
Apr 20, 2022Copper Contributor
Riny_van_Eekelen That was easy, duh. Thanx much
- mathetesApr 20, 2022Silver 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.