divinding part of a number

[Solarissf]

hopefully someone can help me out with this, driving me nuts
If I have a number:

106.05

I want to divide whatever is after the decimal by 32.

In the above example
106.05
I want to take (5/32) = .15625

another example
106.10
(10/32) = .3125

Anyone know a formula to do this???

Thanks in advance

[Toppers]

=(MOD(A1,1)/32*100)

Provided you only have 2 digits after the decimal place

123.456 would give result of 1.425 - is this correct?

HTH

"Solarissf" wrote:

>
> hopefully someone can help me out with this, driving me nuts
> If I have a number:
>
> 106.05
>
> I want to divide whatever is after the decimal by 32.
>
> In the above example
> 106.05
> I want to take (5/32) = .15625
>
> another example
> 106.10
> (10/32) = .3125
>
> Anyone know a formula to do this???
>
> Thanks in advance
>
>
> --
> Solarissf
> ------------------------------------------------------------------------
> Solarissf's Profile: http://www.excelforum.com/member.php...o&userid=34834
> View this thread: http://www.excelforum.com/showthread...hreadid=553246
>
>

[hans bal(nl)]

use (106.05 - INT(106.05))/32

"Solarissf" wrote:

>
> hopefully someone can help me out with this, driving me nuts
> If I have a number:
>
> 106.05
>
> I want to divide whatever is after the decimal by 32.
>
> In the above example
> 106.05
> I want to take (5/32) = .15625
>
> another example
> 106.10
> (10/32) = .3125
>
> Anyone know a formula to do this???
>
> Thanks in advance
>
>
> --
> Solarissf
> ------------------------------------------------------------------------
> Solarissf's Profile: http://www.excelforum.com/member.php...o&userid=34834
> View this thread: http://www.excelforum.com/showthread...hreadid=553246
>
>

[Bob Phillips]

=MOD(A1,1)*100/32

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Solarissf" <[email protected]> wrote
in message news:[email protected]...
>
> hopefully someone can help me out with this, driving me nuts
> If I have a number:
>
> 106.05
>
> I want to divide whatever is after the decimal by 32.
>
> In the above example
> 106.05
> I want to take (5/32) = .15625
>
> another example
> 106.10
> (10/32) = .3125
>
> Anyone know a formula to do this???
>
> Thanks in advance
>
>
> --
> Solarissf
> ------------------------------------------------------------------------
> Solarissf's Profile:
http://www.excelforum.com/member.php...o&userid=34834
> View this thread: http://www.excelforum.com/showthread...hreadid=553246
>

[tim m]

Do you always have 3 digits in front of the decimal? Is so this might work,
=(A1-(LEFT(A1,3)))*100/32

(If there are more or less than 3 digits in front of the decimals this
formula will not work.)

"Solarissf" wrote:

>
> hopefully someone can help me out with this, driving me nuts
> If I have a number:
>
> 106.05
>
> I want to divide whatever is after the decimal by 32.
>
> In the above example
> 106.05
> I want to take (5/32) = .15625
>
> another example
> 106.10
> (10/32) = .3125
>
> Anyone know a formula to do this???
>
> Thanks in advance
>
>
> --
> Solarissf
> ------------------------------------------------------------------------
> Solarissf's Profile: http://www.excelforum.com/member.php...o&userid=34834
> View this thread: http://www.excelforum.com/showthread...hreadid=553246
>
>

[Solarissf]

works guys... THANKS!!!!