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
|