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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
You must log in or register to reply here.

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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
product code a value 0
Compare 1 cell to column of cells returning adjacent cells info? 1
Vlookup to total hours billed 1
Copying a cell ref. down a column, changing worksheet # along the 5
Using names referencing a cell in another workbook 2
Lookup multiple cell values and place contents in a single cell 3

Back
Top