+ Reply to Thread
Results 1 to 3 of 3

Need help with IF solutions

  1. #1
    Registered User
    Join Date
    05-21-2020
    Location
    Texas
    MS-Off Ver
    MS Office 365
    Posts
    1

    Question Need help with IF solutions

    I am adding Cell A1+A2. The only thing is if the numbers in these cells are either both positive or both negative. I need them to be subtracted, the Max-Min. I have tried a few ways and this is what i ended with so far and still need that last little bit of help.


    Edit.
    Normally either A1 or A2 will be negative, and both numbers will be ADDED together. If both numbers are positive or negative then the have to SUBTRACTED. The larger number subtracted by the smaller number.
    Attached Files Attached Files
    Last edited by KCarmichael87; 05-21-2020 at 04:44 PM.

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Need help with IF solutions

    A4 =abs(a1)-abs(a2)
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Need help with IF solutions

    I don't get this, but maybe try

    =ABS(ABS(A1)-ABS(A2))

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Looking for some solutions in my work
    By akash211 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 11-24-2014, 05:36 AM
  2. Hi, I'm new here, looking for a few solutions
    By Gifted Ed in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 11-17-2014, 08:58 PM
  3. editing while filtered or combining from multiple sheets?
    By jbaich in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-22-2013, 05:51 PM
  4. Solutions for Data
    By mathanraj76 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-09-2013, 09:34 AM
  5. IF with 3 possible solutions
    By jomili in forum Excel General
    Replies: 6
    Last Post: 09-14-2010, 08:41 AM
  6. Explaining Your Solutions
    By papaexcel in forum ExcelTip.com Feedback / Comments / Suggestions
    Replies: 8
    Last Post: 12-11-2009, 05:00 PM
  7. vba solutions a.s.a.p please
    By RELWOD85 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-01-2005, 01:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1