find minimum increment

[Excel777]

hi i need a formula to solve this problem
0.005 and numbers like that results should be 23/100 = 0.001
0.09 and numbers like that results should be 23/100 = 0.01
1.230 and numbers like that results should be 23/100 = 0.01
1.10 and numbers like that results should be 1/10 = 0.1
123 and numbers like that results should be 1
1027 and numbers like that results should be 10
any help

 

[PeteWright]

Hi @Excel777,

Could you make an Excel Workbook with some examples, because I don't get the "23/100" part.

 

[etaf]

nor i ,

I also dont understand the

numbers like that

Rather have a range , so no assumptions are made

 

[Excel777]

i mean i want the the minimum increment number after the decimal point
1.20
the minimum of .20 is 01

 

[etaf]

i'm sorry i still have no idea.

 

[Excel777]

something like trunc formula

 

[Sulprobil]

MrExcel_find minimum increment.xlsx
	A	B
1	0,005	0,001
2	0,09	0,01
3	1,23	0,01
4	1,1	0,1
5	123	1
6	1027	1
MinIncrement

Cell Formulas
Range	Formula
B1:B6	B1	=10^(--RIGHT(TEXT(A1,"#,###############E+000"),4)+7-LEN(TEXT(A1,"#,###############E+000")))

 

[Excel777]

Sulprobil MILLION OF THANKS DEAR THAT'S EXACTLY WHAT I NEED BRILLIANT​

 

[Excel777]

is this the formula it gives me different results

=10^(--RIGHT(TEXT(A1,"#,###############E+000"),4)+7-LEN(TEXT(A1,"#,###############E+000")))

123
result
0.1

 

[Fluff]

Maybe

+Fluff v2.xlsm
	A	B
1	0.005	0.001
2	0.09	0.01
3	1.23	0.01
4	1.1	0.1
5	123	1
6	1027	1
Main

Cell Formulas
Range	Formula
B1:B6	B1	=10^-IFERROR(LEN(A1)-FIND(".",A1),0)