Dear All,
First of all my English Language not good but I hope all will be understand. Thers is anyway someone can help me please, I need to know what is the function if I want to calculate decimal only, for example:
56.333
2.378
129.238
14.313
134.566
0.988
0.004
0.212
Total is: 338.032
I want total in two cells (338 in one cell and 032 in separte cell) like this:
338
032
I used this function: ==INT(SUM(A1:A8)) it gives me 338
but what is the other function I can use to calculate only decimal?
For your kind information, I used Excel 2007
Please for quick help.
Thank.
Best Regards,
Mostafa Saqallah
email: m_saqallah@hotmail.com
Bookmarks