Dear All,
Sorry again for disturbing you, but again I faced problem in the function. For example:
62.500
62.500
26.738
26.350
62.500
62.500
Total is: 303.088
I used this function in seperate cell: =INT(SUM(A1:A6)) it gives me 303 (It's correct)
But when I used this function in other cell: =MID(SUM(A1:A6),FIND(".",SUM(A1:A6))+1,5) It gives me (#VALUE)
Could you please give the correct function I can used in two cells (303 in one cell and 088 in separte cell) like this:
303
088
Please for quick help.
Thank.
Best Regards,
Mostafa Saqallah
Bookmarks