1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

formula - conditional - in EXCEL

Discussion in 'Business Applications' started by shortcut, Nov 3, 2003.

Thread Status:
Not open for further replies.
Advertisement
  1. shortcut

    shortcut Thread Starter

    Joined:
    Feb 15, 1999
    Messages:
    255
    Running EXCEL in ME on a HP8260. I put a formula in a cell and it works just fine. If the result is between -25% and -100% I want to print a red XXX.

    The formula in cell C9 is (A9-B9)/B9*100

    How can I make it print the correct answer except if the result is between -25% and -100%? and then print RED XXX's?

    I have been all over the IF function and no help.

    Ideas?

    Thanks,
    shortcut
     
  2. nukeawhale

    nukeawhale

    Joined:
    Aug 13, 2003
    Messages:
    44
    Try this forumula:

    =IF(((A9-B9)/B9*100)< -0.25, "XXX",((A9-B9)/B9*100))

    Then you can apply conditional formatting using "Format" "Conditional Formatting" on the menubar.
    Make Cell Value Equal To XXX, then click on the Format button, then the Color button on the Font tab. Change the color to red.
     
  3. CastleHeart

    CastleHeart

    Joined:
    May 4, 2002
    Messages:
    743
    just a wee little whale change:

    this:
    =IF(((A9-B9)/B9*100)< -25, "XXX",((A9-B9)/B9*100))

    or this:
    =IF(((A9-B9)/B9)< -0.25, "XXX",((A9-B9)/B9*100))

    and you might need to use a <= depending on how you want to treat -0.25%



    ;) - C
     
  4. shortcut

    shortcut Thread Starter

    Joined:
    Feb 15, 1999
    Messages:
    255
    Thanks. I knew someone out there had it. Will try and let you know how it works.
    shortcut
     
  5. shortcut

    shortcut Thread Starter

    Joined:
    Feb 15, 1999
    Messages:
    255
    Thanks again! Works like a charm!!!!!
    shortcut
     
  6. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/176634

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice