Min if formula

[ginamarieann]

I have a range of 4 numbers, both positive and negative and I want the max number, but if the max number is greater than zero, then I want to return zero.

[Jonmo1]

Try

=MIN(0,MAX(A1:A4))

[Richard Buttrey]

Hi,

Assuming the numbers are in A1:A4 then

Please Login or Register  to view this content.