| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Use criteria for values in range for small function
I have a range (a1:a5) with values such as:
0, 5, 25, 0, 3 I want to pick the smallest value other than zero because I will use that number to divide by and do not want the #DIV/0! error. However, the initial state of the spreadsheet will have a range of: 0,0,0,0,0,0 How can I have the spreadsheet display some text until data is entered into the spreadsheet? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Use criteria for values in range for small function
For the min value that is not zero, use the array formula
=MIN(IF(A1:A50,A1:A5)) To enter an array formula, commit it with Shift-Ctrl-Enter "like2hike" wrote: I have a range (a1:a5) with values such as: 0, 5, 25, 0, 3 I want to pick the smallest value other than zero because I will use that number to divide by and do not want the #DIV/0! error. However, the initial state of the spreadsheet will have a range of: 0,0,0,0,0,0 How can I have the spreadsheet display some text until data is entered into the spreadsheet? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Passing a range name as an argument to the Index Function | Excel Discussion (Misc queries) | |||
| Excel COUNTIF Function - a range as criteria ? | Excel Worksheet Functions | |||
| creating function (vba) with range arguments | Excel Worksheet Functions | |||
| Number range function | Excel Discussion (Misc queries) | |||
| Disjoint range for DSUM criteria | Excel Worksheet Functions | |||
Linear Mode
