Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Min function without zeros
I have a spreadsheet with 4 cells in four different worksheets that I want to
find the min value that isn't zero. How can I make the Min function work and not pick up the zero? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Min function without zeros
=MIN(IF(A1:A10<0,A1:A10))
which is an array formula, so commit with Ctrl-Shift-Enter, not just Enter. -- --- HTH Bob (change the xxxx to gmail if mailing direct) "dragea" wrote in message ... I have a spreadsheet with 4 cells in four different worksheets that I want to find the min value that isn't zero. How can I make the Min function work and not pick up the zero? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Min function without zeros
I tried the formula but it gives me an error because all the cells aren't
together in the same worksheet. Here is what I tried =MIN(IF('Admissions Monthly'!AD129,'Adolescent Monthly'!AD129,'GAC Monthly'!AD129,'GAD Monthly'!AD129<0,'Admissions Monthly'!AD129,'Adolescent Monthly'!AD129,'GAC Monthly'!AD129,'GAD Monthly'!AD129)) "Bob Phillips" wrote: =MIN(IF(A1:A10<0,A1:A10)) which is an array formula, so commit with Ctrl-Shift-Enter, not just Enter. -- --- HTH Bob (change the xxxx to gmail if mailing direct) "dragea" wrote in message ... I have a spreadsheet with 4 cells in four different worksheets that I want to find the min value that isn't zero. How can I make the Min function work and not pick up the zero? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Date & Time | New Users to Excel | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |