Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Significant figures

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    How do I round a number to, say, 3 significant figures?

    e.g.

    123456 goes to 123000
    123654 goes to 124000

    1234 goes to 1230
    1245 goes to 1250 (round upwards)

    123 goes to 123 (unchanged)
    1.234 goes to 1.23
    0.0001234 goes to 0.000123

    I think you can do it by taking logs and using the ROUND function, but is there a more direct method?

    Thanks!

  2. #2
    Board Regular Steve Hartman's Avatar
    Join Date
    Feb 2002
    Location
    Houston,Texas
    Posts
    417
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    =ROUND(A1,A2-1-INT(LOG10(A1)))

    where A1 is the number to round and A2 is the number of signficant digits to round to.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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