View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Solarissf
 
Posts: n/a
Default 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