View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John C[_2_] John C[_2_] is offline
external usenet poster
 
Posts: 1,358
Default How to set the formula - part 2?

The second set of data fails on this for the same reason as vezerid's, the -2
needs to be changed to a -1 if the first 2 signficant digits are =36.
--
** John C **

"zorzal" wrote:

I checked one or two but I believe this formula will give you what you
need:

=10^-(INT(LOG(A1))-2)

HTH

Zorzal