Abstract

What if you need to increment a number on its lowest significant digit?

Example: You have the number 123.4567. Now you need a function to determine 0.0001.

Solution:

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

Increment_Lowest_Significant_Digit

Please note that German Excel functions and decimal separator “,” are used in above graphic.

Download

Please read my Disclaimer.

Increment_Lowest_Significant_Digit.xlsx [10 KB Excel file, open and use at your own risk]