Adding and subtracting rows

Copper Contributor

I want to add row A to row B and the answer to appear in row C

And the rows where A is < than B I want it to subtract and put the answer in row C as a negative number and then total the column

This doesn't seem as easy as it should be for 684 rows

1 Reply

@BigGF Perhaps like this. In A1 and copy down.

=IF(A1>=B1,A1+B1,A1-B1)