Hi,

I am wondering if anyone can help me with the following statement.

I have a number (example 1.068501) which i need to round up to 3
decimal places or 4 significant figures if the number is greater than 1
so the result would be 1.069.

If the number was (example 0.926145) then we need to round up to 4
decimal places or 4 significant figures so the result would be in this
example would be 0.9262.

Can someone please provide me with a formula for this sort of
calculation as I have a spreadsheet of over 500 numbers!

Cheers in advance


--
mccrimmon


------------------------------------------------------------------------
mccrimmon's Profile: http://www.excelforum.com/member.php...fo&userid=6338
View this thread: http://www.excelforum.com/showthread...hreadid=555957