| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
using min function without calculating 0 as minimum
I have a column with different values like this and so on I want to
calculate =Min(B1:B20) but I do not want to have 0 as minimum value. I this function not to calculate 0 and tell me 2 as minimum value. here is the example: 2 6 54 4 0 5 8 87 54 56 12 0 answer here is "0" but i want to have "2" as minimum value. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set a minimum value to be returned from IF function | Excel Discussion (Misc queries) | |||
| Minimum function | Excel Discussion (Misc queries) | |||
| minimum function | Excel Worksheet Functions | |||
| Can I retrieve a value and its format using the minimum function? | Excel Worksheet Functions | |||
| calculating the minimum value ignoring o | Excel Worksheet Functions | |||
Threaded Mode
