Forum Discussion
BigGF
Mar 23, 2022Copper Contributor
Adding and subtracting rows
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
- Riny_van_EekelenPlatinum Contributor
BigGF Perhaps like this. In A1 and copy down.
=IF(A1>=B1,A1+B1,A1-B1)