Excel?

Collapse

Recommended Videos

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • 500bloc
    MVP
    • May 2003
    • 1279

    #1

    Excel?

    I'm having difficulty coming up with an excel formula. I want to have numbers in a particular column come in between a low of 0 and a high of 99.

    The thing is I don't know how to do it. It sounds simple enough but I'm still a beginner in this.

    The problem arises when a sum comes up as a negative number (ex. -13). And I'm trying to keep it between 0 & 99.


    I would appreciate the help.
  • mudman
    Rookie
    • Sep 2003
    • 200

    #2
    Re: Excel?

    So you're summing numbers in a column, some negative and some positive obviously.

    Assuming that's correct:

    You could use an if statement to check the sum and if it's negative it would just put a 0, if it's greater than 99 it would just put a 99, and if it's neither, then it would just put the number.

    I'm not sure how that would help since I have no idea what you're doing this for, but that's an option.

    Comment

    • HotSauce2k3
      MVP
      • Nov 2002
      • 1848

      #3
      Re: Excel?

      A lot of my Excel macro and formula issues answered by Google and/or Excel forums.

      Comment

      • stizz
        MVP
        • Sep 2006
        • 1718

        #4
        Re: Excel?

        What I would do is first find the smallest negative number, eg. -13. Then I'd add that to all numbers, so add 13 to all numbers. I would then find the new max number and divide all numbers by that new max and times by 99.
        Last edited by stizz; 06-14-2010, 11:19 PM.

        Comment

        Working...