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...
Riny_van_Eekelen
Mar 23, 2022Platinum Contributor
BigGF Perhaps like this. In A1 and copy down.
=IF(A1>=B1,A1+B1,A1-B1)