Adding of numbers in excel sheet with attached condition
I have certain values in column A and B of an Excel sheet (copy enclosed).
I want to add the values in column A and B and exhibit the result in column C.
The addition has however a condition
a) All the Negative values in A and B must be increased first by +100 (ie. +100 must be added to the negative integer),
b) and then taken up for addition with the second integer
c) and the resulting solution (answer) must be exhibited in its absolute value
(ie. only the absolute value or the difference between the two numbers alone is exhibited)
Can anyone help me with formula towards the same please!
I have enclosed below the solution for values in rows 1 to 3 for reference please.

OP-Levels CP-Levels Formula required Answer Answer(ABS value)
200 -223.6 = 200+ (-223.6+100) 76.4 76.4
-176.4 -223.6 =(-176.4+100)+(-223.6+100) -200 200
-138.2 76.4 =(-138.2+100)+76.4 38.2 38.2

With thanks
shree18

=ABS(IF(A1<0,A1+100,A1) + If(B1<0,B1+100,B1))

Put that in the C Column.

Quote:

---

Originally Posted by ScottGem

=ABS(IF(A1<0,A1+100,A1) + If(B1<0,B1+100,B1))

Put that in the C Column.

---

Thanks sir
shree18