Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula for Sequencing Totals
I created an Excel sheet for calculating the cost of items when a value is
entered in two cells. The formula in cost column for each row is: =IF(ISERROR(G3/F3),"",G3/F3) I also have a cell that shows me the lowest number in the column: =MIN(I3:I34) I would like to create cells that will show me the next lower number and then a cell to show the next lower number to that. I would only like to display the 5 lowest numbers and as you can see I can easily show the lowest. I don't know what formula to use in the consecutive cells to show the next to lowest and so on. Thanks for any help. Jeff |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Excel 97 - Adding Every 8th Row - Formula should work, but doesn't | Excel Worksheet Functions | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |