Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations KootK on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Gryantaylor

    Excel Solver: Set target cell to a cell reference instead of a value

    Another option would be to subtract the value you want from the target cell and then set solver to a value of zero (or min if you use the abs function). With this method solver has the same settings everytime and you don't need to learn VB.
  2. Gryantaylor

    Rounding Up

    Never mind, I just reread the post. electricpete is right, I don't think you can format the cells to round up. But you can write your own roundup function :)
  3. Gryantaylor

    Rounding Up

    you can preform text functions on a numeric value. SO... search for the "." in the text string <<find(".",A1))>>, then take everything before that location in the text string minus one <<Left(A1,find(".",A1)-1)>> Finaly just add one <<Left(A1,find(".",A1)-1)+1>> and you'll have a simple formula...

Part and Inventory Search