Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extracting dollars and cents
B1: =INT(A1)
C1: =(A1-B1)*100 (custom format 00) "Pradhan" wrote: I have a task which I would assume would be really simple, but I am going thru hoops to get this done, and there MUST be a simpler way. What I want to do is separate and extract the dollars and cents from one figure. For example, $1000.07, I need to extract this (for forms) to 2 separate numbers...1000 (the dollar side) and 07 (the cent side WITHOUT a decimal point, and must show 07, not just 7) The dollar side is easy...I just use the TRUNC command, but the cents side is painful because Excel calculates out to x decimal points so I can't use the RIGHT command. What I end up doing is taking the dollar amount, subtracting the TRUNCATED amount, multiplying by 100, adding 100. (In the above case, this would yield 107...but actually 106.9999986). So I then need to ROUND this and at last, take the RIGHT 2 characters. There has got to be a better way to go from 1000.07 to 07. Any help would be kindly appreciated. Pradhan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting dollars and cents | Excel Worksheet Functions | |||
dollars/cents multiplied by hours/minutes or tenths | Excel Worksheet Functions | |||
how do i sum dollars & cents in different columns | Excel Worksheet Functions | |||
Splitting dollars and cents | Excel Discussion (Misc queries) | |||
Separating dollars and cents | Excel Worksheet Functions |