| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Decimal Places
If I have a number in a cell (e.g., 3.456), how can I return just the decimal
part of it (0.456) to another cell? Conversely, if I have Cell 1 = 50 and Cell 2 = 55, how can I join them in a new cell to make the number 50.55? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Decimal Places
=MOD(A1,1)
=A1+A2/100 -- Regards, Peo Sjoblom "college student ATL" <college student wrote in message ... If I have a number in a cell (e.g., 3.456), how can I return just the decimal part of it (0.456) to another cell? Conversely, if I have Cell 1 = 50 and Cell 2 = 55, how can I join them in a new cell to make the number 50.55? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Decimal Places
Your second formula fail, if
A1= 50 A2= 578 =A1+A2/100 Your formula returns 55.78, should be 50.578 Teethless mama formula return 50.578 =A1+A2/(10^LEN(A2)) "Peo Sjoblom" wrote: =MOD(A1,1) =A1+A2/100 -- Regards, Peo Sjoblom "college student ATL" <college student wrote in message ... If I have a number in a cell (e.g., 3.456), how can I return just the decimal part of it (0.456) to another cell? Conversely, if I have Cell 1 = 50 and Cell 2 = 55, how can I join them in a new cell to make the number 50.55? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Decimal Places
Slightly more efficient:
=--(A1&"."&A2) In article , Teethless mama wrote: Your second formula fail, if A1= 50 A2= 578 =A1+A2/100 Your formula returns 55.78, should be 50.578 Teethless mama formula return 50.578 =A1+A2/(10^LEN(A2)) "Peo Sjoblom" wrote: =MOD(A1,1) =A1+A2/100 -- Regards, Peo Sjoblom "college student ATL" <college student wrote in message ... If I have a number in a cell (e.g., 3.456), how can I return just the decimal part of it (0.456) to another cell? Conversely, if I have Cell 1 = 50 and Cell 2 = 55, how can I join them in a new cell to make the number 50.55? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Decimal Places
Teethless mama formula return 50.578
=A1+A2/(10^LEN(A2)) Two parentheses more than needed... =A1+A2/10^LEN(A2) Rick |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Decimal Places | Excel Discussion (Misc queries) | |||
| Subtracting two 2-decimal place numbers gives result 13-decimal places? | Excel Worksheet Functions | |||
| Decimal Places | Excel Discussion (Misc queries) | |||
| Max decimal places | Excel Discussion (Misc queries) | |||
| FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) | |||
Linear Mode
