MIN excluding 0
Solved
Coco-8
Posted messages
94
Status
Membre
-
TPR1-KM -
TPR1-KM -
Bonjour, I would like to execute the MIN function over a specific range of cells but I want it to ignore the cells that contain the value 0. Just like the AVERAGEIF function (MOYENNE.SI) does with criteria (“<>0”).
Example:
A1=5
A2=9
A3=0
A4=2
=MIN(A1:A4) = 2 and not 0.
Example:
A1=5
A2=9
A3=0
A4=2
=MIN(A1:A4) = 2 and not 0.
3 réponses
Hello,
Use the following formula:
=MIN(IF(A1:A4<>0,A1:A4))
This is an array formula. Validate it using ctrl+shift+enter
--
To conquer without peril is to triumph without glory.
Pierre Corneille, Le Cid
Use the following formula:
=MIN(IF(A1:A4<>0,A1:A4))
This is an array formula. Validate it using ctrl+shift+enter
--
To conquer without peril is to triumph without glory.
Pierre Corneille, Le Cid
Coco-8
Posted messages
94
Status
Membre
2
Thank you!
TPR1-KM
Clear, concise, and effective explanation! Thank you!
