Search results

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

Hi Got that, can manage the one drop down but not the insert of a number in the next column cell. Also text in select box is too small

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...

Hi SirJB7 works great, many thanks Sam

Thanks for this I will take a look over the weekend Regards sam

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.

Here it is One file is as per my comments above and the other is an example I found on the web but not too sure if it gives me what I want. https://www.dropbox.com/s/qlsejdwp2u4m12r/Cert%20pass%20ratios%20v3.zip Sam

How do I do that?

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%...

Hi Jason What a star you are, I was worried about how to make this work over the weekend. A big, big thank you. Sam

Hi Jason giant sized improvement This works for all numbers except the threshold numbers - 10, 50, 100 & 250 or above give a false return. Sam

Hi Jason ...where did the 'if <4 then 100' come from? Sorry I used this when I was considering a change threshold of 5, the rest is for the same reason is 0 ever a possibility? No

Hi Jason this appears to work for the first two conditions: =IF(E2=1,25,IF(E2<4,100,(100+((E2-4)*25)))) Hope that answers your question Sam

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...