Chemaz Posted September 5, 2011 Share Posted September 5, 2011 Basically i would like excel to round a number thats between 1.441 and 2.49 to 2, odd i know, but sure how to do it really, tried searching for it but can only find different function to round .5 either up or down, rather than a custom rule Any help or advice on this would be amazing :) Link to comment Share on other sites More sharing options...
0 mastermate Posted September 8, 2011 Share Posted September 8, 2011 Although not strictly rounding in the true sense: In another field, say B1: =IF(AND(A1>=1.441,A1<=2.49),2,A1) where A1 contains the value to 'round' Link to comment Share on other sites More sharing options...
0 Kami- Posted September 9, 2011 Share Posted September 9, 2011 Create a custom function in the VBE to do what you desire... Link to comment Share on other sites More sharing options...
Question
Chemaz
Basically i would like excel to round a number thats between 1.441 and 2.49 to 2, odd i know, but sure how to do it really, tried searching for it but can only find different function to round .5 either up or down, rather than a custom rule
Any help or advice on this would be amazing :)
Link to comment
Share on other sites
2 answers to this question
Recommended Posts