Excel 2007 : Round Up Decimals

Hi: I am totally new to Excel and not very computer literate either.

I am setting up a rather simple spreadsheet with a formula that divides cell G4 by A4. The actual numbers are $120,000/$223,956,073. This results in a decimal of .000535819 in H4. I want to round this decimal up to .000536.

I have tried following the insructions in the "help" windows, to no avail. And the instructions seem to indicate that one particular number or cell must be processed each time. Sometimes I get the "circular'' warning, but I do not yet have any other formulae on my spreadsheet

What I really want to do is set the entire column to round up each cell in the H column as I make entries in columns G and A

An example of the proper formula that I must use would be most welcome. Edit: I should have noted that I want to use the up-rounded decimal as a multipler with other columns. I did manage to achieve a rounded decimal display, but when used as a multiplier, the results were that from original decimal. Also,In found that I could "force" rounding by narrowing the column width. Kind of squeezes the decimal and it rounds up, but only visually.

Thanks,
Ron Reeland

Hi librarycustodian,

Try this in H4:

Please Login or Register  to view this content.

Cheers,

You always want it to round UP, you could try CEILING:

=CEILING(G4/A4,0.000001)