1 Replies - 3787 Views - Last Post: 31 August 2012 - 03:52 PM Rate Topic: -----

#1 achavez  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 8
  • Joined: 16-August 12

showing decimal as 32nd

Posted 20 August 2012 - 08:27 AM

Hope to find some help!

A1 has 101.265625
In 32nd's this should be 101-084
in B1 is there a formula I can do to show 101-084?

This is the formula i am using to TRY to get 101-084

=SUBSTITUTE(DOLLARFR(A1, 32), ".", "-") HOWEVER, this returns 101-085 and not 101-084

Any help?
Thanks!
Is This A Good Question/Topic? 0
  • +

Replies To: showing decimal as 32nd

#2 BobRodes  Icon User is offline

  • Your Friendly Local Curmudgeon
  • member icon

Reputation: 574
  • View blog
  • Posts: 2,989
  • Joined: 19-May 09

Re: showing decimal as 32nd

Posted 31 August 2012 - 03:52 PM

You have a rounding error that isn't easy to solve. This formula seems to do the trick:
=INT(DOLLARFR(B2,32)* 100)/100+DOLLARFR(MOD(B2,1/32),256)

where your input number is in cell B2.

The INT function strips off all but the first two decimals. DOLLARFR gets the .08 from this number. Then take the remainder of the input number divided by 1/32, and apply DOLLARFR to the result.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1