+ Reply to Thread
Results 1 to 4 of 4

IF statement emergency!!

  1. #1
    Registered User
    Join Date
    05-09-2013
    Location
    Midland Texas
    MS-Off Ver
    Excel 2007
    Posts
    3

    Exclamation IF statement emergency!!

    I need some help finishing (or correcting) the following formula: =IF(-G2,H2 else display H2 as a positive number

    Basically what happened is I have a spreadsheet that was exported from another source and one column is displaying a negative number but the result in the column next to it shows as a positive. I need to make it where it will also show as a negative number (can't just format the cell, it doesn't know the source had calculated it as a negative)

  2. #2
    Registered User
    Join Date
    05-09-2013
    Location
    Midland Texas
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: IF statement emergency!!

    Oops, I made an error. What I have so far is +IF(-G2,-H2

  3. #3
    Registered User
    Join Date
    04-30-2013
    Location
    Idaho, USA
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: IF statement emergency!!

    =if(g2<0, -h2, h2)

  4. #4
    Registered User
    Join Date
    05-09-2013
    Location
    Midland Texas
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: IF statement emergency!!

    IT WORKED!! Thank you SO much!!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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