I want to extract the first,second and third decimal place from this formula,then add on some if statements.How can i do it?
Assume that your number (1000.456) is in cell B2.
In A4, put 2, in A5 put 3, in A6, put 4 (Will it only be three digits to the right of the decimal? If more, you can extend the list in column A, i.e. if four digits, then put 5 in A7, etc.)
In cell B4 put this formula:
Then autofill this formula down, as far as the numbers in column A. (note: the double negative forces the result to be a number (otherwise these formulas produce text).
old, slow, and confused
but at least I'm inconsistent!