Sam_UK Posted March 26 Share Posted March 26 I'm sure this is simple and I just haven't been able to find the answer on the forum. I am doing a finishings schedule, I am using the formula #=ROUND('Space_Finish'.'NetArea')# which gives me the rounded down to the nearest m² . I would like this to not be rounded or if it has to be then I would prefer roundup not down. any help would be appreciated. Quote Link to comment
0 markdd Posted March 26 Share Posted March 26 There is a ROUNDUP worksheet function you could try. I haven't tried it in the Space finishes, and this is not really my specialism, however, if you use the Worksheet section of the data tag, you can use the ROUNDUP function with a rounding index of 0, and you should get what you need. Quote Link to comment
0 Sam_UK Posted March 26 Author Share Posted March 26 Thanks @markdd that has worked I was typing it in incorrectly, however my next issue is that only some of my areas are being filled in the worksheet. Not sure what is coursing this. Quote Link to comment
Question
Sam_UK
I'm sure this is simple and I just haven't been able to find the answer on the forum.
I am doing a finishings schedule, I am using the formula #=ROUND('Space_Finish'.'NetArea')# which gives me the rounded down to the nearest m² .
I would like this to not be rounded or if it has to be then I would prefer roundup not down.
any help would be appreciated.
Link to comment
2 answers to this question
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.