Ask Experts Questions for FREE Help !
Ask
    shree18's Avatar
    shree18 Posts: 4, Reputation: 1
    New Member
     
    #1

    Jun 10, 2013, 04:07 AM
    Adding of numbers in excel sheet with attached condition
    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
    Attached Files
  1. File Type: zip addition of data.zip (8.0 KB, 47 views)
  2. ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
     
    #2

    Jun 10, 2013, 04:44 AM
    =ABS(IF(A1<0,A1+100,A1) + If(B1<0,B1+100,B1))

    Put that in the C Column.
    shree18's Avatar
    shree18 Posts: 4, Reputation: 1
    New Member
     
    #3

    Jun 12, 2013, 11:45 AM
    Quote Originally Posted by ScottGem View Post
    =ABS(IF(A1<0,A1+100,A1) + If(B1<0,B1+100,B1))

    Put that in the C Column.
    Thanks sir
    shree18

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

How to connect one excel sheet to other excel sheet [ 28 Answers ]

How to connect one excel sheet to other excel sheet.

How to link multiple excel sheets to one main source excel sheet [ 7 Answers ]

I have a master price list and multiple ( individule ) sheets for customers.. I would like to , when input data in the price list to link and update to all other sheets... ( I do not want to have a source sheet with tabs) Thanks

Excel - Input numbers in sheet1a1 (Using several numbers separately) going to separat [ 2 Answers ]

I want to be able to put over 100 different numbers (not at the same time) all on sheet1 A1 to direct to there own sheet. Each individual number will go to a different sheet(only 1 number per sheet) Please help

Excel-adding numbers pulled in from another sheet [ 5 Answers ]

I know I know the solution to this but it has been 2 years since I even opened an Excel Spreadsheet... Anyway, lets say I have a column on Sheet1 pulling in numbers from Sheet2. On Sheet1, I want to SUM the total value of the numbers that are being pulled over.. but I am just getting 0 Can...


View more questions Search