divinding part of a number

S

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
 
T

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
 
B

Bob Phillips

=MOD(A1,1)*100/32

--
HTH

Bob Phillips

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

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