LinkBack URL
About LinkBacks
Im trying to round decimals into 0.5 integers however if the decimal is 3 decimal point near a .5 it skips to a whole and if 3 decimals to a whole skip to the next 0.5
the xl file explains better... i think :/
Im trying to round decimals into 0.5 integers however if the decimal is 3 decimal point near a .5 it skips to a whole and if 3 decimals to a whole skip to the next 0.5
the xl file explains better... i think :/
Okay... try using below formula:-
Formula:
Please Login or Register to view this content.
Let me know if this works.. else let me know the error
Regards,
DILIPandey
<click on below * if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com
In B1, =FLOOR(A1+0.8, 0.5)
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks