Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MIN
I have this formula:
=MIN(U11:U40,H7)+P8 how do i fix it so that it will take the min of the array but not a 0 (zero) value? For example the formula should give me 2.20 and not zero as the example shows. U 11 5.15 12 3.14 13 0 14 2.20 15 7.90 16 10.00 17 0 Thanks in advance. DSQ |