Need to use numbers to right of decimal only
 

I need to create a formula that will allow me to use the numbers to
the right of the decimal place of a number only. I need to determine
how much material the decimal number represents. For example. I have a
formula that returns a result of 7.234 the .234 needs to be multiplied
against another number to determine the amount of waste material this
represents. Can someone help me with this?
thank you in advance,
Rudy

Need to use numbers to right of decimal only
 

=MOD(A2,1)
--
David Biddulph

"rudyeb" wrote in message
...
I need to create a formula that will allow me to use the numbers to
the right of the decimal place of a number only. I need to determine
how much material the decimal number represents. For example. I have a
formula that returns a result of 7.234 the .234 needs to be multiplied
against another number to determine the amount of waste material this
represents. Can someone help me with this?
thank you in advance,
Rudy

Need to use numbers to right of decimal only
 

=MOD(number,1)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"rudyeb" wrote in message
...
I need to create a formula that will allow me to use the numbers to
the right of the decimal place of a number only. I need to determine
how much material the decimal number represents. For example. I have a
formula that returns a result of 7.234 the .234 needs to be multiplied
against another number to determine the amount of waste material this
represents. Can someone help me with this?
thank you in advance,
Rudy