Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 4 of 4

Thread: Show specific text based on number value in other cell

  1. #1
    Join Date
    9th February 2011
    Posts
    2

    Show specific text based on number value in other cell

    If anybody can help me with this I'd be very grateful.

    What I want to do is basically assign a flag (based on conditional formatting) according to a number value. Sounds simple.

    I'm looking at birth rates, in 2010 there might be 100. In 2009 there were 99.

    I want to do 3 things. If the percentage change in birth rate between the years is either 0, OR is between 0 and 1, then I want to say it's stable. If it goes up or down by more than a percentage I want it to say "Increase" or "Decrease". It's the between 0 and 1 range I'm having difficulty with.
    The formula I have is along the lines of:

    =IF(AND(AG9>=99,AG9<=101),"stable"),IF(AG9>101,"Increase",IF(AG9<99,"decrease"))

    Not terribly difficult, but's it's driving me mad and I don't have much time..

    Would be very grateful for any pointers
    Last edited by AAE; February 9th, 2011 at 21:43. Reason: revise thread title

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    2nd May 2008
    Location
    Ubique
    Posts
    1,893

    Re: Displaying "increase", "decrease" or "stable" depending on number value

    Guessing at your layout:
    =IF(ABS(AG9-AF9)<=1,"Stable",if(AG9>AF9,"Increase","Decrease"))

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    9th February 2011
    Posts
    2

    Re: Displaying "increase", "decrease" or "stable" depending on number value

    Where ABS is the positve difference between the two? I.e. regardless of whether -1 or +1, the difference being 1?

    I've just tried =IF(AG9>101,"Increase",IF(AG9<99,"decrease","stable")), that works, but I like the abs function

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    2nd May 2008
    Location
    Ubique
    Posts
    1,893

    Re: Displaying "increase", "decrease" or "stable" depending on number value

    Correct.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Replies: 2
    Last Post: February 1st, 2011, 15:47
  2. Replies: 1
    Last Post: July 22nd, 2006, 01:20
  3. Replies: 2
    Last Post: August 27th, 2005, 18:19
  4. Replies: 2
    Last Post: May 7th, 2005, 07:43

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
  •  
porno