Need to use numbers to right of decimal only

R

rudyeb

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
 
B

Bob Phillips

=MOD(number,1)

--
HTH

Bob

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
How to count the numbers in a Word document? 0
How can the font and size of (all) citation numbers be altered? 1
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0
Read Only now different 1
Decimal 1
Getting numbers on the right side of the decimal point 5
Finding the right style field in VBA 0

Top