Increment Lowest Significant Digit

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")))
Please note that German Excel functions and decimal separator "," are used here

Please read my Disclaimer.

Please note that you need to change "#,###############E+000" to "#.###############E+000" for an international, a US, or a UK version of Excel (see code block above, please).