Round numbers in no of digits
On Jun 10, 8:26*pm, gopi wrote:
How to convert this type of numbers in one formula
* * * * * * * * 1145 =1150
* * * * * * * * 1141 =1150
* * * * * * * * 1149 =1150
* * * * * * * * 12458=12460
Perhaps ROUNDUP(A1,-1), where A1 contains the number.
But note that 1140.0001 will round up to 1150. Is that acceptable?
|