Format Cells

[Dane]

Within a cell-I have created a formula for multiplication
although I want the formula / calculation to "round-up".
It seems when the cells multiple / add etc I am off a few
cents???

 

[Bob Phillips]

=ROUND(A1*A2,2)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Charley Kyd]

If you always want to round up, check out the CEILING function.

Charley Kyd