Announcement

Collapse
No announcement yet.

Unconfigured Ad Widget

Collapse

Display Plus Sign For Positive Numbers

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Display Plus Sign For Positive Numbers

    If you have a formula lets say (sum A1-A2) and the total is negative i.e. A1 is 100, A2 is 50 would return -50, how do you get the value to show a plus sign if the value is positive? i.e. if A2 is 100 and A1 is 50, excel would simply show 50, but I'd like it to show +50.

    Also, if the result is 0, so both A1 and A2 are 50, how do I get Excel to display the words On Forecast in a cell?

    Thanks in advance

    Andie

  • #2
    Re: Automatically Putting A Plus Sign If Number Is Positive

    One possibility would be to use the custom number format. Right Click > Format Cells > Number Tab. By selecting the Custom category you can enter a customised format string in the Type box.

    You would need something like +#;-#;"On Forecast" or if you wanted to show one decimal +#.0;-#.0;"On Forecast".

    HTH
    Carl
    Last edited by Dave Hawley; November 20th, 2006, 08:57.
    locii Insight
    Locii Solutions. Business IT Training. Business Consulting. Excel Training. Business Intelligence using Excel 2010. Cyprus.

    Comment


    • #3
      Re: Automatically Putting A Plus Sign If Number Is Positive

      Brilliant, thats worked Carl, however, before I applied it the number if greater than a thousand used to display with a comma as a separator and now it doesn't, i.e. it was 1,000, now it's 1000, do you know how I add the , back in?

      Comment


      • #4
        Re: Automatically Putting A Plus Sign If Number Is Positive

        Use

        +#,###;-#,###;"On Forecast"
        .

        Comment


        • #5
          Re: Automatically Putting A Plus Sign If Number Is Positive

          Bingo

          Thanks ByTheCringe2!
          Last edited by Dave Hawley; November 20th, 2006, 14:52.

          Comment


          • #6
            Re: Display Plus Sign For Positive Numbers

            ByTheCringe2,
            Thankyou for stepping in,

            Regards
            Carl
            locii Insight
            Locii Solutions. Business IT Training. Business Consulting. Excel Training. Business Intelligence using Excel 2010. Cyprus.

            Comment


            • #7
              Re: Display Plus Sign For Positive Numbers

              Cheers, each.

              Carl, I learnt a bit doing that!
              .

              Comment

              Trending

              Collapse

              There are no results that meet this criteria.

              Working...
              X