+ Reply to Thread
Results 1 to 3 of 3

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

  1. #1
    Forum Contributor
    Join Date
    02-25-2012
    Location
    Coimbatore, India
    MS-Off Ver
    Excel 2010
    Posts
    445

    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.

    Old thread link for reference :
    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.

    thanks in advance

    thilag
    Attached Files Attached Files

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

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

    How 22 Row is negative, what is the logic here
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  3. #3
    Forum Contributor
    Join Date
    02-25-2012
    Location
    Coimbatore, India
    MS-Off Ver
    Excel 2010
    Posts
    445

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 08-07-2014, 01:20 AM
  2. [SOLVED] Max. & Min. values from the set of alternate positive and negative numbers.
    By thilag in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 08-06-2014, 05:57 AM
  3. Convert negative to positive in sheet containing both positive/negative numbers
    By sa02000 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-29-2010, 07:52 PM
  4. Replies: 1
    Last Post: 11-20-2008, 01:52 AM
  5. Replies: 4
    Last Post: 09-26-2005, 06:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1