Rounding Help Please

G

Govind

Hi,

Pls describe what do you want precisely.

If you want a function to round, use the function

=round(a1,1) to round off a number to 1 decimal
=round(a1,-1) to round off a number to nearest 10
=round(a1,-2) to round off a number to nearest 100

Govind.

C.L.A (PTY) Ltd wrote:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

rounding a number up to a certain ending digit 6
Round it off 3
Round Off 3
Calculating Sum - when numbers are rounded... 2
Convert inches & display as Feet Inches and Fractions -- BUG FREE 12
IF and Round 5
rounding formulas 2
time calculation 8

Top