Jump to content
  • 0

Worksheet roundup trouble





I have a column with decimal values representing power consumption, in watts.

In the next column I would like to know how many of my 600w power supply units I have to allocate.


So I need to round up, but I cannot seem to make it work, it just writes out the formula indicating that something is not right.


=ROUND(F2/600, 1) works , but rounds anything under 600 to zero.


the worksheet function is documented as follows:


roundup(number, digits)

Rounds the specified number up to a specified number of decimal digits.

=roundup(2.345, 2) returns 2.35


If I use the formula from the example, I get the same result, it just writes out the formula


Any ideas?











Edited by fuberator
Link to comment

3 answers to this question

Recommended Posts

  • 0

There does not seem to be a roundup function using the Data Tag formatting.  But you can convert it to use #WS_ # functions instead and use Roundup there.

Untested, but something like:




This should round to 2 decimal places. Change the last 2 to however many decimals you want.

Link to comment

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.

Answer this question...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...