Jump to content
• 0

# Worksheet roundup trouble

## Question

Hi

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?

Cheers

F

Edited by fuberator

## Recommended Posts

• 0

I found my own solution, I used "=ceiling(F2/600)" and set the format of the cell to decimal with 0 decimals

Edited by fuberator
##### Link to comment
• 0

Following up on the monologue thread.

I would now like to round up inside a data tag.

Is there a way to add rounding (up) to this tag definition: (#Screens#.#Load#*#Screens#.#Tubes#*20)*3/512

Cheers

##### Link to comment
• 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:

#WS_Roundup((Screens.Load*Screens.Tubes*20)*3/512,2)#

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

## 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.

×
×

• KBASE
• #### MARIONETTE

×
• Create New...