find minimum increment

Excel777

Well-known Member
Joined
Jul 3, 2009
Messages
892
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
 

Some videos you may like

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

PeteWright

New Member
Joined
Dec 20, 2020
Messages
23
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
  2. Mobile
  3. Web
Hi @Excel777,

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

Excel777

Well-known Member
Joined
Jul 3, 2009
Messages
892
i mean i want the the minimum increment number after the decimal point
1.20
the minimum of .20 is 01
 

etaf

Well-known Member
Joined
Oct 24, 2012
Messages
4,413
Office Version
  1. 365
Platform
  1. MacOS

ADVERTISEMENT

i'm sorry i still have no idea.
 

Sulprobil

Board Regular
Joined
May 12, 2020
Messages
141
Office Version
  1. 2016
Platform
  1. Windows

ADVERTISEMENT

MrExcel_find minimum increment.xlsx
AB
10,0050,001
20,090,01
31,230,01
41,10,1
51231
610271
MinIncrement
Cell Formulas
RangeFormula
B1:B6B1=10^(--RIGHT(TEXT(A1,"#,###############E+000"),4)+7-LEN(TEXT(A1,"#,###############E+000")))
 

Excel777

Well-known Member
Joined
Jul 3, 2009
Messages
892
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

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
53,148
Office Version
  1. 365
Platform
  1. Windows
Maybe
+Fluff v2.xlsm
AB
10.0050.001
20.090.01
31.230.01
41.10.1
51231
610271
Main
Cell Formulas
RangeFormula
B1:B6B1=10^-IFERROR(LEN(A1)-FIND(".",A1),0)
 

Watch MrExcel Video

Forum statistics

Threads
1,123,010
Messages
5,599,330
Members
414,305
Latest member
scarletX

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top