Thread: Largest value in a range
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
Milos Setek Milos Setek is offline
external usenet poster
  
Posts: 12
Default Largest value in a range
And the winner is Mayur. Thank you lots for that and it is non-array!



"Mayur" wrote in message
...
=IF(ABS(MAX(range))<ABS(MIN(range)),MIN(range),MAX (range))


Reply With QuoteReply With Quote