| Home |
| Search |
| Today's Posts |
|
#6
|
|||
|
|||
using this formula, how do you get it to show the lowest positive number????
"Harlan Grove" wrote: "Aladin Akyurek" wrote... Harlan Grove wrote: .... =IF(A655360,A65536,LOOKUP(2,(A1:INDEX(A1:A65535 , MATCH(9.99999999999999E307,A1:A65535))^-0.5)^-2 The idea is worth considering. That is, replacing 1/x with x^-0.5. Is the formula complete as posted? Um, no. Not correct. Try this instead. =IF(A655360,A65536,LOOKUP(2,(A1:INDEX(A1:A65535, MATCH(9.99999999999999E307,A1:A65535)))^-0.5)^-2) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What formula is used for subtracting a range of different cells f. | Excel Worksheet Functions | |||
| Formula to count the cells in a range that have a fill color. | Excel Discussion (Misc queries) | |||
| Excel - formula to calculate colored fill cells within a range wi. | Excel Worksheet Functions | |||
| to copy a formula in cell c1 (+b1/b11) to cells c2-10, how can i . | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
