Results 1 to 2 of 2
  1. #1
    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. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Welcome to the board.

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

Posting Permissions

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