Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by 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.- Gryantaylor
- Post #12
- Forum: -Engineering spreadsheets
-
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 :)- Gryantaylor
- Post #8
- Forum: -Engineering spreadsheets
-
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...- Gryantaylor
- Post #7
- Forum: -Engineering spreadsheets
