Using Mod operation without integer rounding

[realace112]

I'm trying to get the fraction part of a number. For example, if x = 115.5, I need 0.5 . What I tried using was a Mod operation to get the remainder however it converts and rounds the answer to an integer. Instead of getting 0.5, I get 1. Is there a way I can use Mod and get a decimal value instead of an integer? Please advise. I am a beginner to VB so please bare with me. Thank you.

 

[peekay]

Try this

Answer=x-int(x)

PK Odendaal

http://www.odendaal.com

 

[MichaelRed]

per peekay and the ubiquitous {F1}] (aka help) the short and real answer is NO. mod, re the docs:

... Usually, the data type of result is a Byte, Byte variant, Integer, Integer variant, Long, or Variant containing a Long, regardless of whether or not result is a whole number. Any fractional portion is truncated. However, if any expression is Null, result is Null. Any expression that is Empty is treated as 0.

MichaelRed
mlred@verizon.net