fuberator Posted February 13 Share Posted February 13 (edited) 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 February 13 by fuberator Quote Link to comment

0 fuberator Posted February 13 Author Share Posted February 13 (edited) I found my own solution, I used "=ceiling(F2/600)" and set the format of the cell to decimal with 0 decimals Edited February 13 by fuberator Quote Link to comment

0 fuberator Posted February 15 Author Share Posted February 15 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 Quote Link to comment

0 Pat Stanford Posted February 15 Share Posted February 15 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. Quote Link to comment

## Question

## fuberator

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.35If 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## Link to comment

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