Thanks Ron. I think I also meant to use Log10() also.
Dana


Ron Rosenfeld wrote:
On Tue, 31 Mar 2009 20:46:00 -0400, Dana DeLouis
wrote:

Just guessing here...

=INT(A1/POWER(10,CEILING(LOG(A1/2025),1)))

= = =
Dana DeLouis

I like the approach a lot, but it returns an error when A1=10.065.

Perhaps:

=INT(A1/POWER(10,INT(LOG(A1/2025)+1)))

--ron