Results 1 to 2 of 2

030905, 03:26 #1Registered User
 Join Date
 Mar 2005
 Posts
 1
Unanswered: How to extract the decimal places from a number??
Hi all,
As i need to check the decimal places of a number:
1000.456
For example:The first decimal place :4
How can i extract it?
=IF(AND(C10<>0,
C10>J9),C10+J10,CEILING(POWER(SUM(1,(F5/1200)),F3)*(F5/1200)*(C4/(POWER(SUM(1,(F5/1200)),F3)1)),1))
The statement above results to:
=11514.615
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?Thanks a lot

030905, 11:47 #2Registered User
 Join Date
 Oct 2003
 Posts
 1,091
Welcome to the board.
Originally Posted by aijihz
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:
=LEFT(RIGHT($B$2,FIND(".",$B$2)$A4),1)
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!
Rich
(retired Excel 2003 user, 3/28/2008)
How to ask a question on forums