Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Montano

  1. Montano

    X Axis Labels

    When doing a graph and there both positive and negative values on the graph and the axis cross at zero, the x axis labels automatically run along the middle of the graph. I want to move the labels down out of the middle of the graph but not change where the axis crosses. Is there a way to keep...
  2. Montano

    Formula with negative values

    How do I write a growth formula that I can copy across 12 months where some of the numbers are negative and some are positive? For example: 2005: (202) 2004: (49) My current formula is giving me 312% growth, when the percentage should be negative because we lost more than the prior year...
  3. Montano

    Countif Function with Multiple Conditions

    I may have posed the question wrong. I basically want to know in a column of percentages, I want to break out the percentages into groupings. For example: <50% 51% to 60% 61% to 70% 71% to 80% >81% If there is a column of 50 percentages, how many fall into each bucket?
  4. Montano

    Countif Function with Multiple Conditions

    If you have a column of percentages, and you need to get the sum of how many cells fall into designated ranges, how do you use the countif function with multiple criteria? For example, how do you get the number of cells that contain the percentages that are greater than 60% but less than 70%?
  5. Montano

    Convert time in Seconds

    Is there a way to convert Unix time in seconds to a regular format? Time in Seconds: 1118875557 Time in UTC: 6/3/2005 8:06:23 PM
  6. Montano

    Formula when Goal is a Negative Number

    Here is an example: Goal (7,000) Actual - can be a positive number or negative against the goal of (7,000) % Achieved: _______ If this category represents 40% of the bonus plan, then the % achieved is used to arrived at how much of the 40% is achieved. However, the qualifier is that...
  7. Montano

    Formula when Goal is a Negative Number

    I need to do a formula for a bonus spreadsheet. The goal is a negative number. I need to write the formula for the % achieved of goal so that it works whether the actual is negative or positive against the negative goal. Also, the result of the answer requires two qualifiers: If it less...
  8. Montano

    Excel

    I would like to get the average of a column of numbers, but I need for the formula to exclude any zeros in the column. How do I write this formula?
  9. Montano

    Min (ignore values less than zero)

    In a range of numbers, I want to get the mininum value but ignore any values less than zero. How do I write this formula?
  10. Montano

    Excel &quot;IF&quot; Statement

    Here's an example: Curr YR (370) Prior YR (968) How can you write the formula to get the correct % growth?
  11. Montano

    Excel &quot;IF&quot; Statement

    Can you do an &quot;IF Statement&quot; with two criteria? Example: If I have two numbers and I am trying to get a percentage of growth, how can I write the formula so that it works whether both numbers are positive, both numbers are negative, or one is negative and one is positive? Thanks...
See more

Part and Inventory Search

Back
Top