+ Reply to Thread
Results 1 to 7 of 7

IF formula to show negative value

  1. 11-12-2023, 06:12 AM #1
    ricky-84
    ricky-84 is offline
    Registered User
    Join Date
    03-18-2018
    Location
    San Francisco
    MS-Off Ver
    MS 2013
    Posts
    73

    IF formula to show negative value

    Hello,

    Need help figuring out how to write formula in attached file. What I'm trying to do is, in Cell D5:E7 contains the data. As per the rule in Cell G3:G5, I need a formula in Cell D10 that would display the result I need depending what I have in Cell C3. According to the rule, if I have a upslope runway (Cell C3), I need the value from Cell D7 to show in Cell D10. If the opposite it true where I have a downslope runway, I need the value from Cell E7 to show in Cell D10. Since Cell C3 shows "dn", that would mean in Cell D10 should read "-180" because I need to decrease that value from the value in Cell D9.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 11-12-2023, 06:15 AM #2
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    81,211

    Re: IF formula to show negative value

    Are you still using Excel 2010? If not, plase update your profile.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 11-12-2023, 06:19 AM #3
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    81,211

    Re: IF formula to show negative value

    How about this?

    =HLOOKUP(C3,D6:E7,2,0)*IF(C3="dn",-1,1)
    Reply With QuoteRegister To Reply
  4. 11-12-2023, 06:20 AM #4
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,099

    Re: IF formula to show negative value

    E10:

    =E7*IF(C3="dn",-1,1)
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
    Reply With QuoteRegister To Reply
  5. 11-13-2023, 12:37 AM #5
    ricky-84
    ricky-84 is offline
    Registered User
    Join Date
    03-18-2018
    Location
    San Francisco
    MS-Off Ver
    MS 2013
    Posts
    73

    Re: IF formula to show negative value

    Quote Originally Posted by AliGW View Post
    Are you still using Excel 2010? If not, plase update your profile.
    Yes, at home. However, I use whatever version work has installed. Profile update.
    Reply With QuoteRegister To Reply
  6. 11-13-2023, 12:42 AM #6
    ricky-84
    ricky-84 is offline
    Registered User
    Join Date
    03-18-2018
    Location
    San Francisco
    MS-Off Ver
    MS 2013
    Posts
    73

    Smile Re: IF formula to show negative value

    Quote Originally Posted by AliGW View Post
    How about this?

    =HLOOKUP(C3,D6:E7,2,0)*IF(C3="dn",-1,1)
    Quote Originally Posted by Glenn Kennedy View Post
    E10:

    =E7*IF(C3="dn",-1,1)

    Thank you both for the help. Both formula's does the trick and what I was looking for.
    Reply With QuoteRegister To Reply
  7. 11-13-2023, 03:25 AM #7
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    81,211

    Re: IF formula to show negative value

    Glad to have helped.

    If you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula To Show Negative Hours On Timesheet
    By SoulfulNeo in forum Outlook Formatting & Functions
    Replies: 1
    Last Post: 01-17-2023, 01:33 PM
  2. [SOLVED] Apply IF to a Formula to show the result only if a negative number.
    By guardian46w in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-27-2019, 01:48 AM
  3. Formula to determine if a number is negative in D6 and if negative show C6?
    By Mr.Castle in forum Excel General
    Replies: 7
    Last Post: 07-10-2018, 01:05 PM
  4. [SOLVED] Formula to show positive number instead of negative
    By werko in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-10-2015, 04:24 AM
  5. Need to add to a working if formula to show negative
    By IreneADS in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-16-2014, 03:24 PM
  6. [SOLVED] Show zero in this VALUE formula instead of negative number
    By islandeeya in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-30-2014, 04:41 PM
  7. Date formula if positive show, if negative don't show.
    By Cyberpawz in forum Excel General
    Replies: 8
    Last Post: 03-14-2012, 07:49 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1