divinding part of a number
 

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

divinding part of a number
 

=(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

divinding part of a number
 

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

divinding part of a number
 

=MOD(A1,1)*100/32

--
HTH

Bob Phillips

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

"Solarissf" wrote
in message ...

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

divinding part of a number
 

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

divinding part of a number
 

works guys... THANKS!!!!


--
Solarissf
------------------------------------------------------------------------
Solarissf's Profile: http://www.excelforum.com/member.php...o&userid=34834
View this thread: http://www.excelforum.com/showthread...hreadid=553246