Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing numerical values based upper and lower range
I need to change some upper and lower values of some numerical data based on
a upper and lower range. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing numerical values based upper and lower range
That is more of a statement than a question. We need a lot more details than
that. -- HTH... Jim Thomlinson "jrmcosmo" wrote: I need to change some upper and lower values of some numerical data based on a upper and lower range. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing numerical values based upper and lower range
What formula or statement can I use to change numerical values that I want to
keep above a certain lower limit and below a certain upper limit? Say I wanted to keep the values above 10 but below 20. "Jim Thomlinson" wrote: That is more of a statement than a question. We need a lot more details than that. -- HTH... Jim Thomlinson "jrmcosmo" wrote: I need to change some upper and lower values of some numerical data based on a upper and lower range. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing numerical values based upper and lower range
So you have a set of existing numbers that you want to change such that they
fit between an upper and a lower limit. there are an infinite number of ways that that can be done depending what you want. 1 Way - Any number above the upper limit becomes the upper limit and numbers below become the lower limit. Another Way - Lets say your exising numbers are from 0 to 100 and you want them to be proportionally spread between 10 and 20. The difference between 10 and 20 is 10. The difference between 0 and 100 is 100. 10/100 = 0.10. Multiply all of the existing numbers by 0.10 and then add 10 to them. -- HTH... Jim Thomlinson "jrmcosmo" wrote: What formula or statement can I use to change numerical values that I want to keep above a certain lower limit and below a certain upper limit? Say I wanted to keep the values above 10 but below 20. "Jim Thomlinson" wrote: That is more of a statement than a question. We need a lot more details than that. -- HTH... Jim Thomlinson "jrmcosmo" wrote: I need to change some upper and lower values of some numerical data based on a upper and lower range. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing numerical values based upper and lower range
=MEDIAN(A1,10,20)
I assume that you don't actually mean "above 10", but that you mean "greater than or equal to 10", and that you don't actually mean "below 20" and that you mean "less than or equal to 20". With the same assumptions, an alternative would be =IF(A1<10,10,IF(A120,20,A1)) and another alternative would be =MAX(10,MIN(A1,20)) -- David Biddulph "jrmcosmo" wrote in message ... What formula or statement can I use to change numerical values that I want to keep above a certain lower limit and below a certain upper limit? Say I wanted to keep the values above 10 but below 20. "Jim Thomlinson" wrote: That is more of a statement than a question. We need a lot more details than that. -- HTH... Jim Thomlinson "jrmcosmo" wrote: I need to change some upper and lower values of some numerical data based on a upper and lower range. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing multiple cell text from lower case to upper case | Excel Discussion (Misc queries) | |||
Changing upper case characters to upper/lower | Excel Discussion (Misc queries) | |||
Changing file in all upper case to upper and lower case | Excel Discussion (Misc queries) | |||
Change from mixed caps and upper lower to all upper lower case | Excel Worksheet Functions | |||
Return Range of Numerical Values in Single Column based on Frequency Percentage | Excel Worksheet Functions |