| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Determine next level from a table
I have a table that has the following information. Let's say that in c5 a
result of 350 was calculated. What type of formula would I use showing that the next level from the table is 400? If c5=480, the next level would be 500. low high a b c5=350 200 299 300 399 400 499 500 599 600 699 700 799 800 899 900 999 1,000 1,099 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| determine the name of the selected pivot table | Excel Discussion (Misc queries) | |||
| 2-level subtotals? | Excel Discussion (Misc queries) | |||
| Pivot Table - report product that have sales above defined level | Excel Discussion (Misc queries) | |||
| Determine the location of an external source of pivot table? | Excel Worksheet Functions | |||
| Sum to Defined level | Excel Discussion (Misc queries) | |||
Threaded Mode
