MS Office Excel 2000- round cell values

Hi all,
In cell A4 on a worksheet, I have a calculated value (SUM=)
The cells in the formula have up to two decimal positions and
there are multiplications, additions and divisions in the formula.
How do I specify that the result in cell A4 should always be rounded up to an integer- a whole number without decimal places ?
Thanks for any help on this.
regards

 

Setting the cell format as a number with zero decimal places will force the displayed value to be rounded. Not always up but in accordance with usual rounding rules. Note that the underlying value will remain as it was and only the display will appear rounded.

If you want to force the value to the nearest integer higher than the decimal number, you'll need to do a little more formula work.

So - what is it, exactly, that you want to happen?

 

Hi Newt and thanks for the reply. Here's an example ...
Cell (A4) = Cell (A1) * Cell(A2)
= 3.33 * 3.00
in A4 I want to see the integer 10 and the value 10 to be used
if any other calculations which use Cell A4
If, as you suggest, I set the decimal places for A4 to zero,
A4 shows up as integer 3

regards

 

Excel Help and search for rounding which should give you about 5 sub-choices. Good explanations there of how to force rounding of a number.

 

Had a look at those before Newt, thanks.
They all seem to refer to rounding a number and not the value
in a cell.
Pls post example of how you would do what I want as above.
Thanks and best regards

 

Found out how to do it.
Here's an example ...
Setting a cell to
=ROUNDUP(SUM(AG7:AG10),0)
will sum AG7 to AG10 and round up the result into the cell
with zero decimal places.
ROUNDDOWN can also be used
regards