KuraiChikara
Board Regular
- Joined
- Nov 16, 2016
- Messages
- 111
- Office Version
- 2013
- Platform
- Windows
Hello,
I was wondering how to combine an IF calculation to end in an ABS within the same formula. For example
CELLS
A1=-5
A2=-6
IF(A1="","",((A1+A2)))
The end result will be -11, but I dont want that. I would like to include the absolute value function (ABS) within the IF function so it would return 11 (positive).
I was wondering how to combine an IF calculation to end in an ABS within the same formula. For example
CELLS
A1=-5
A2=-6
IF(A1="","",((A1+A2)))
The end result will be -11, but I dont want that. I would like to include the absolute value function (ABS) within the IF function so it would return 11 (positive).