View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Praveen Praveen is offline
external usenet poster
 
Posts: 2
Default finding maximum, minimum in a range consists both Positive and Negative numbers

Hi , i need help to write a user defined functions to find positive
maximum and positive minimum
and also negative maximum and negative minimum from a range consists
of both positive and
negative numbers.

ex: 15,18,12,7,3,-9,-13,-23
In my requirement the result should come as
Positive Max: 18
Positive Minimum :3
Negative Maximum: -9
Negative minimum : -23

Thanks in advance for your response.