Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
decimals only.
Hello,
I have a requirement to ignore the whole number in a sum and just use the decimals. To be more specific if I can get 6.54 lengths of metal from a bar length of 4000mm what size is the offcut? I can find lots of info on ignoring the decimal but none on ignoring the whole number. Any help appreciated! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
decimals only.
When I have to get the decimal, I just use a formula. Say:-
A1 = 6.54 A2 will contain the offshoot fraction/decimal 0.54 Put into A2 " = a1-trunc(a1,0) " which will give you 0.54. Just reply if it doesn't work and i'll try and help. -- Dave "joepose" wrote: Hello, I have a requirement to ignore the whole number in a sum and just use the decimals. To be more specific if I can get 6.54 lengths of metal from a bar length of 4000mm what size is the offcut? I can find lots of info on ignoring the decimal but none on ignoring the whole number. Any help appreciated! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
decimals only.
Hi,
you can use formula: =A1-INT(A1) if the number is in cell A1 to get number as 0,54 or =(A1-INT(A1))*100 to get 54 Regards, Nika Lampe "joepose" je napisal: Hello, I have a requirement to ignore the whole number in a sum and just use the decimals. To be more specific if I can get 6.54 lengths of metal from a bar length of 4000mm what size is the offcut? I can find lots of info on ignoring the decimal but none on ignoring the whole number. Any help appreciated! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
decimals only.
Hi joepose,
Have a look at the TRUNC and INT functions in help. With 6.54 in A1 =A1-TRUNC(A1) will equal 0.54 =A1-INT(A1) will equal 0.54 HTH Martin |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
decimals only.
"MartinW" wrote in message
... Hi joepose, Have a look at the TRUNC and INT functions in help. With 6.54 in A1 =A1-TRUNC(A1) will equal 0.54 =A1-INT(A1) will equal 0.54 As will MOD(A1,1) -- David Biddulph |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
decimals only.
You have been given some good replies but please note if A1 = -1.56 then
=A1-TRUNC(A1) gives -0.56 (negative) but =A1-INT(A1) gives 0.46 (positive) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "joepose" wrote in message ... Hello, I have a requirement to ignore the whole number in a sum and just use the decimals. To be more specific if I can get 6.54 lengths of metal from a bar length of 4000mm what size is the offcut? I can find lots of info on ignoring the decimal but none on ignoring the whole number. Any help appreciated! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Displaying a number with different decimals depending on a condition | Excel Worksheet Functions | |||
Convert $ amount from excel to access? No decimals but 00 at end | Excel Worksheet Functions | |||
How do I change the number format for decimals from , to .? | Setting up and Configuration of Excel | |||
Pivot table formats text data with 2 decimals | Excel Discussion (Misc queries) | |||
How do I calculate without decimals in excel? | Excel Worksheet Functions |