Rounding

[Mike1w]

What is the best way to round up the ansewer from a forumla the cell = 9875 and I want it to round to 9900 the problem is the cell =(sheet 1 cell a5*0.85) it gives me the ansewer but how do I round up the ansewer within the same cell??

[Dav]

=round(sheet 1 cell a5*0.85,-2)

is one option, is that what you mean?

Regards

Dav

[chandan12]

We can do this by the following way

cell=round(a5*.83,-2)

if we use the cell value of another sheet
cell=round(sheet2!a5*.83-2)