| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
So many greater than and less than values to calculate
I need to get this formula into a single cell
=if(x <999 then A =if(x is between and inclusive to 1000-1500 then B =if(x is between and inclusive to 1501-2500 then C =if(x is between and inclusive to 2501-3500 then D =if(x is between and inclusive to 3501-4500 then E =if(x is between and inclusive to 4501-5500 then F =if(x is between and inclusive to 5501-7000 then G =if(x is between and inclusive to 7001-10000 then H =if(x is between and inclusive to 10001-15000 then I =if(x is between and inclusive to 15001-20000 then J =if(x is between and inclusive to 20001-30000 then K =if(x 30001 then L I then have to run it down 10,000 rows to define a new value for each row cell How best to do it? You're much brighter than I am! Ta! Geezer |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate rolling average using last 30 values greater than 0. | Excel Discussion (Misc queries) | |||
| Need a formula to calculate greater than & show answer as a % | Excel Worksheet Functions | |||
| Advanced Filter for Values in Column M greater than Values in Colu | Excel Discussion (Misc queries) | |||
| How can I count values greater than and less than certain values? | Excel Worksheet Functions | |||
| calculate the number of words in a row whose length is greater than 2 | Excel Worksheet Functions | |||
Threaded Mode
