Results 1 to 8 of 8

Formula using arrow icons to show trend

Threaded View

  1. #1
    Registered User
    Join Date
    02-19-2007
    Posts
    43

    Formula using arrow icons to show trend

    I'm trying to create a formula where I can show the trend of two values from one month to the next that shows wheather the results went up or down in a positive or negetive value. For example:

    If I have a transfer % of 18% in October and November MTD is at 17% - the arrow would then reflect downward showing in green, as the lower percentage is better. but I need the arrow to show upward in Red if say the value for November MTD was 19% instead.

    I tried conditional formatting and attempted an "If" formula. I must not have all the information to create the formula as it errors out on me. I can create it if only looking to reflect one arrow...

    =if(c3<b3,"↓")

    Any help is greatly appreciated.

    FYI - I have excel 2007.
    Last edited by casdaq; 11-16-2009 at 07:55 PM.

Thread Information

Users Browsing this Thread

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

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