# Thread: How to extract the decimal places from a number??

1. Registered 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

2. Registered User
Join Date
Oct 2003
Posts
1,091
Welcome to the board.

Originally Posted by aijihz
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?
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:

=--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).

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•