# Max. & Min. values from the set of alternate positive & negative numbers

1. ## Max. & Min. values from the set of alternate positive & negative numbers

Hello Friends

Please refer the attached 2010 Excel file : <Angle in Excel5.xlsx>.

I want to calculate the maximum and minium numbers (For 2 columns) from
the set of alternate positive and negative numbers.

http://www.excelforum.com/excel-form...e-numbers.html

Requirements :
1) If a set of Positive values in `C' column then the maximum and minimum values to be plotted in Cells G (From Column A) & Cells H (From Column B)
2) If a set of Negative values in `C' column then the maximum and minimum values to be plotted in Cells G (From Column A) & Cells H (From Column B)
Note : The positive and negative values will change alternatively so that the formulas should be taken care of this.
3) If Zeros `0' Available then it should be taken as Negative value if it is available in the Negative set of light green cells
4) If Zeros `0' Available then it should be taken as Positive value if it is available in the Positive set of light Yellow cells
5) If Zeros `0' occurs in between inbetween Negative and Positive Set then take it as Positive Set.
6) If Zeros `0' occurs in between inbetween Positive and Negative Set then take it as Negative Set.
7) Note : If the Zero `0' in between Negative and Positive Set (Point 5) & Positive and Negative Set (Point 6) then you can the zero as Positive or Negative value (Vice versa for Point 5 & 6) Since it is not a big deal. But the Points 1) to 4) are obvious requirements.

Thanks to XOR Lx for help against old post.

Just reference sheet is only for reference.

The values are to be plotted in yellow cells.

thilag  Register To Reply

2. ## Re: Max. & Min. values from the set of alternate positive & negative numbers

How 22 Row is negative, what is the logic here  Register To Reply

3. ## Re: Max. & Min. values from the set of alternate positive & negative numbers

Hello nflsales

it is a typo error, make B22 & K5 = 436 instead 440 then the value in C22 = -2.

sorry

thanks

thilag  Register To Reply