TimG Posted February 27, 2012 Share Posted February 27, 2012 hey all, looking for a way to round gross perimeter to the nearest inch or even foot in my worksheet... tried =(ROUND('Space'.'11_Gross Perim')) but get a return that looks something like 79'3.799" to 658,061,065.0 any ideas? Quote Link to comment
michaelk Posted February 27, 2012 Share Posted February 27, 2012 =ROUND('Space'.'Gross Perim') will round the value up or down as appropriate =INT('Space'.'Gross Perim') will chop off the decimal/fractional values hth mk Quote Link to comment
TimG Posted February 27, 2012 Author Share Posted February 27, 2012 that's exactly what I was looking for, but it does not seam to work with the =int('Space'.'Room Dimensions')... any way to accomplish that.. thanks so much for your help Quote Link to comment
michaelk Posted February 28, 2012 Share Posted February 28, 2012 Would you believe: =CONCAT(INT('Space'.'11_Length'), ''' X ', INT('Space'.'11_Width'), '''') mk Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.