Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
house mouse
 
Posts: n/a
Default How do I ROUNDUP a Column of cells on a worksheet template?

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.

  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
=ROUNDUP(your_formula,0)

"house mouse" wrote:

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.

  #3   Report Post  
house mouse
 
Posts: n/a
Default

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.

"house mouse" wrote:

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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Heps to design Locked/Unlocked cells in protected worksheet Kevin Excel Discussion (Misc queries) 0 December 30th 04 08:09 AM
ADDING SUM TOTAL OF MORE THAN 30 CELLS IN A COLUMN TOGETHER - WON. Robin Smith Excel Discussion (Misc queries) 0 December 20th 04 09:47 PM
Updating database worksheet problem (Template Wizard) grasping@straws Excel Discussion (Misc queries) 1 December 17th 04 03:26 PM
how to copy 2350 hyperlink full paths to any column in a worksheet ? kontiki Excel Discussion (Misc queries) 4 December 10th 04 11:00 PM
How can I merge unlocked cells in a worksheet that has been protec NeedMergeHelp Excel Discussion (Misc queries) 2 December 7th 04 02:20 AM


All times are GMT +1. The time now is 04:41 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"