divinding part of a number

Giganews Newsgroups
Subject: divinding part of a number
Posted by:  Solarissf (Solarissf.29nl3o_1150727102.5389@excelforum-nospam.com)
Date: Mon, 19 Jun 2006

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?action=getinfo&userid=34834
View this thread:http://www.excelforum.com/showthread.php?threadid=553246

Replies