can any one tell me the function which round the friction value if it is equal or grater then 5 otherwise remove it. like 2546.5 show as 2547 or 2546.4 which show 2546 only
can any one tell me the function which round the friction value if it is equal or grater then 5 otherwise remove it. like 2546.5 show as 2547 or 2546.4 which show 2546 only
Last edited by ihtesham; 03-29-2014 at 12:59 PM.
Select the cells an format them to 0 decimal places.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Maybe:
=IF(MOD(A1,1)>=0.5,CEILING(A1,1),FLOOR(A1,1))
Quang PT
Thanks bebo its works..!
Last edited by ihtesham; 03-29-2014 at 12:58 PM.
Sounds like this:
=ROUND(A1,0)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks