Using roundup in a column.

[NANCY55]

Hi I've been breaking my head all morning trying to figure out how I can divide by a constant number, that being 200, in a column but also having it round off to only 2 decimals. I've been using =ROUNDUP(????/200,2) (the number changes in every column) Thats been working for me, BUT I'd like to know if there was a formula where I can just enter the number & have it it roundup & dived without having to put in the formula for every cell in the column. Your help is very much appreciated. Hope you guys can help.

[oeldere]

not sure what you mean, so i take a guess

Please Login or Register  to view this content.

in which a1 = 200

[NANCY55]

Screen Shot 2013-05-03 at 12.06.44 PM.png

I used the 1st method which was =A1/$C$1 but I didn't get how to use roundup with that.

I like the 2nd method which was =ROUNDUP(3643/200,2) but I don't know if I'm able to just apply it to a whole column.
I would like to input a number in each cell within a column & have it divided & rounded up.

Do I make sense?

[FDibbins]

Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info)

[NANCY55]

I'm not familiar with what workbook is. That was just a sample of what I what I'm trying to do. & I just threw in those numbers they're not actual numbers I'm using. or an actual file I'm working on.

[oeldere]

workbook is the excel file your working in.

post this file, without confidentional information.

[MrShorty]

It almost looks to me like you are just unfamiliar with how to build formulas in Excel and using cell references in those formulas and so on. Does this help? http://office.microsoft.com/en-us/ex...997.aspx?CTT=1

[NANCY55]

I'm not sure how to upload a file.

[NANCY55]

I'm using ROUNDUP(number,num_digits) but I want to know if I can use it for a whole column. or would i just have to type it in the cell everytime.

[oeldere]

To Attach a File:

1. Scroll down to the window below your post Additional Options
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.


You could copy the cell into the other cells in the column

[NANCY55]

Thank you. I was able to upload it.

[oeldere]

See the attached file.

It is in the yellow cells.

You can copy the formula to the cells below.

[NANCY55]

I got =IFERROR(ROUNDUP($A1/H$1,2),"") in the yellow cells.