Results 1 to 2 of 2

Thread: Excel - Finding Minimum Possible Positive Value

  1. #1

    Thread Starter
    New Member
    Join Date
    Oct 2005
    Posts
    1

    Excel - Finding Minimum Possible Positive Value

    Hi just wondering if the following is possible in excel to do the following with these colums:
    A B C
    52.7 46.28 1,705.57
    8.5 69.04 -146.67
    16.8 55.63 201.15
    3.4 109.73 -360.39
    41 47.53 1,215.27
    67.5 45.32 2,325.78
    6.7 76.32 -222.10
    6 80.34 -251.44
    7.6 72.25 -184.39
    12.3 60.65 12.57
    8.1 70.38 -163.43

    Total Of Column B = 733.47

    What i have done above, to achieve the values in column C is to multiply the values in Column A x Column B then subtract the total of Column B from this Figure.
    What i would like to know is, can i automatically make excel adjust the values in column B to show the minimum positive value in column C?

    This may not make sense, i hope i have explained it properly.. please any response would be much appreciated

  2. #2
    Addicted Member malik641's Avatar
    Join Date
    Sep 2005
    Location
    South Florida :-)
    Posts
    221

    Re: Excel - Finding Minimum Possible Positive Value

    Do you mean sort the values in column C?

    I'm not sure I understand what you mean by adjusting column B for a minimum value in C. Do you mean sort all the rows by the value in column C?




    If you find any of my posts of good help, please rate it

Posting Permissions

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



Click Here to Expand Forum to Full Width