Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Decimal Numbers typed into Excel 2003 read as whole numbers | Excel Discussion (Misc queries) | |||
Subtracting two 2-decimal place numbers gives result 13-decimal places? | Excel Worksheet Functions | |||
How can I sort mostly 3 decimal with some 4 decimal numbers | Excel Discussion (Misc queries) | |||
Too Many Numbers After The Decimal | Excel Discussion (Misc queries) | |||
How to repalce numbers after a decimal | Excel Discussion (Misc queries) |