Thread: Excel - Min function over 4 separate cells, but ignoring negatives
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
  
Posts: 1,231
Default Excel - Min function over 4 separate cells, but ignoringnegatives
griff wrote...
....
I have been sent a sheet which contains lots of Min formulae which
look for lowest of 4 separate cell values, eg =MIN(M23,J23,G23,D23)

The 'challenge' I have now is to get them to ignore any negative
numbers.
....

=MIN(IF(M230,M23),IF(J230,J23),IF(G230,G23),IF( D230,D23))

or, since these are every 3rd column beginning with column D, you
could use the array formula

=MIN(IF((MOD(COLUMN(D23:M23),3)=1)*(D23:M230),D23 :M23))
Reply With QuoteReply With Quote