Forum Discussion

rcatala3's avatar
rcatala3
Copper Contributor
Apr 20, 2022
Solved

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

    • cjm44's avatar
      cjm44
      Copper Contributor
      what is the subtract y34 from e36
      • mathetes's avatar
        mathetes
        Silver Contributor
        For 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.

Resources