Results 1 to 6 of 6

Using ABS Correctly

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-09-2010
    Location
    London
    MS-Off Ver
    Excel Version Office 365
    Posts
    211

    Using ABS Correctly

    Hi community

    Below is a formula that I am using that combines Index and Match.

    In a tab called CTA, if a number is negative such as -$250,000, it would take that number and make is positive


    =ABS(INDEX(CTA!$AC$14:$AC$1206,(MATCH('MI Reports'!$B3,CTA!$E$14:$E$1206,0))))


    There are instances when the number in CTA tab is positive and I would like that to be shown as negative
    Question:

    How can I modify the above formula to factor, if the number is negative, make it positive, but if the number is positive, make it negative?




    Thanks.
    Last edited by Excel-Access; 06-06-2019 at 10:01 AM. Reason: Wrong description

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to write =IF((E2>75%)+E2*300) correctly
    By TPS in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-10-2018, 10:52 AM
  2. Using =IF correctly?
    By Overdahill in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-14-2018, 08:45 AM
  3. Doing ON KEY Correctly
    By Logit in forum Excel General
    Replies: 2
    Last Post: 12-10-2017, 01:10 PM
  4. [SOLVED] Add-in not loading correctly
    By toddy00 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-08-2016, 11:42 AM
  5. Using formulae correctly
    By jinxtt in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 06-26-2014, 09:46 AM
  6. how to correctly use the IF function
    By penfold1992 in forum Excel General
    Replies: 5
    Last Post: 04-11-2012, 09:42 PM
  7. CSE Sum-if not working correctly
    By krjohnso in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-30-2009, 05:08 PM

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