How do I ROUNDUP a Column of cells on a worksheet template?

H

house mouse

I am using Excel 2000. The work sheet is a production Bill of Materials
Template in which the cell data changes from work sheet to work sheet.
Here is my question.
Cells in Column J = Cells in Column F x Cell A3 which is unit of measure per
order
For the cells in Column I, I want them to = J / Purchase unit of
measure,then round up to next number automatically.

My Dummies book isn't clear on the subject.

Can it be done.
 
H

house mouse

Thanks for the reply. Basically what that does is show me how to do it
manually. I was hoping that I could find a way that it would calculate the
whole function and process the formula at the same time.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compare 1 cell to column of cells returning adjacent cells info? 1
How to do an IF statement that copy data based on a partial match 0
Help Please 6
Vlookup to total hours billed 1
Create if partial match then copy and paste data from one cell to another 1
Loop returns only one value, does not loop & an assignment to columnhow-to problem. 26
Copying a cell ref. down a column, changing worksheet # along the 5
how do i roundup multiple cells? 1

Top