Minimum Value - But Need Help

[will2learn]

I'm using this formula =MIN(O20:O1000) to obtain a mininmum amount. I need to change it so that only the minimum value is picked up if a value grater than zero is in the range L20:L1000.

Can anyone assist?

 

[Peter_SSs]

I'm using this formula =MIN(O20:O1000) to obtain a mininmum amount. I need to change it so that only the minimum value is picked up if a value grater than zero is in the range L20:L1000.

Can anyone assist?

It is unclear whether you want to check column L and if any value is > 0 then find the minimum value in column O, or whether you want to check column L and for the all the rows that are > 0 find the minimum value from column O from those rows.

One of these may suit. If not please try to clarify.

=IF(MAX(L20:L1000)>0,MIN(O20:O1000),"")


=MIN(IF(L20:L1000>0,O20:O1000))
This second formula is an array formula so should be entered as shown but confirmed with Ctrl+Shift+Enter, not just Enter. If confirmed correctly, Excel will insert {} around the formula.