| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Min function excluding zero
hi, i have a set of positive numbers (randomly generated) which includes a
zero . I want to pickout the Min from them which excludes zero. i.e, Min greater than zero. My second question is =if(or(a1=1,a1=2),"A","B")) I modified it to =if(a1={1,2},"A","B"). But This formula is true only for a1=1 any suggestions. Thank you all With regards Sridhar |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excluding subtotals from SUMIF function | Excel Worksheet Functions | |||
| Workday function including sat, excluding sun | Excel Worksheet Functions | |||
| Min Function Excluding Zero Values & More | Excel Worksheet Functions | |||
| Excluding 0s and blanks from a LINEST function | Excel Worksheet Functions | |||
| MIN excluding 0s | Excel Worksheet Functions | |||
Threaded Mode
