Hi again,
Nice to be back, I have one question which do need help. My problem is that, I wish to round all values in cell into the nearest 5. Let say 4.9 should be round as 5, 72 as 70 but 0 should be maintain as 0. There's also exception whereas anything that is greater than 0 such as 0.1,0.2,1.0 etc these values should be as 5.
Is there anyway to accomplish this? please help...
Thank you
=IF(AND(A1>0,A1<2.5),5,ROUND(A1/5,0)*5)
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Hi Dom, thanks for the solution, do help me a lot in looking for the solution. AS my column in percent and any value will automaticllay multiply by 100. Does this formula can be applied to your previous solution? It came out somthing like invalid formulaOriginally Posted by Domski
Formula for precentage column:
=IF(AND(A1>0,A1<2.5),5,ROUND(A1/5,0)*5)/100
Thank you again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks