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