Return Cents (not sense)

[JLC58]

Having trouble determining a formula to return ONLY the cents portion of a column of numbers
i.e. 123.50, 234.50 to return $1.00. Possible for both left and right sides of decimal point? J

 

[Scott Huish]

Your examples don't make sense to me, how does 234.50 return $1.00??

But to answer your question, to get the left side of the decimal point:
If only positive values:
=INT(A1)
If both positive and negative:
=TRUNC(A1)

To get the part after the decimal point:
=MOD(A1,1)

 

[JLC58]

Sorry was adding .50 and .50 equaling 1.00. My bad. J

 

[Scott Huish]

If you're wanting to add them, you could do it without a helper column

Excel 2010
	A	B	C
1	$ 234.50	$ 357.00	$ 1.00
2	$ 123.50
Sheet1

Cell Formulas
Range	Formula
B1	{=SUM(TRUNC(A1:A100))}
C1	{=SUM(MOD(A1:A100,1))}
Press CTRL+SHIFT+ENTER to enter array formulas.