• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. S

    unnecessarily long range

    I have a sheet to represent price of an item by volume. It involves the use of a massive range. Is there any way I can achieve the same without using a range? Sam
  2. S

    Excel 2010 drop down selection

    Hi Again Can any one help? I do not want to use VB. I need to achieve the following: Select a drop down in one column puts a value in the next cell over. Well below average, barely meets minimum requirements. 1 Slightly below average, meets minimum...
  3. S

    price breaks based on volume and a threshold [SOLVED]

    Hi Folks, this is driving me nuts. 1 TO 10 25.00 11 TO 50 15.00 51 TO 100 9.00 101 TO 250 5.40 In this there is an area where it is cheaper to buy for example 12 instead of 10 and I am trying to work out a formula to deal with this funny step change down as people buy more.
  4. S

    Statistics for exam pass rate

    Hi All I am trying to work out how to produce a model that allows me to find optimum sample rate to show a reliable pass rate. This one shows a fixed sample of 25% regardless of pass wanted: 90% pass rate from 25% Exemplar 75% pass rate from 25% Gold 50% pass rate from 25% Silver 40%...
  5. S

    A lot of IF's

    Hi, I am new to excel formulas. I need to do the following: If E2 is 1 then h2 = 25 If E2 is more than 1 but less than 10 H2 will increment by 25 for every digit increase in E2 If E2 is more than 10 but less than 50 H2 = will increment by 18.75 for every digit increase in E2 If E2 is...
Back
Top