Hello,
I would like to round up decimel numbers into whole ones. But, I would like excel to do it this way: if my calculation says that an investment has a return of 13,47% I would like excel to round it up to 15%. Also, if my result is 12,38% I would like excel to round it up to 10%. The thing is, I want it rounded up by 5%. So, if it comes under 12,50% I want 10% and if it comes over 12,50% I would like to round it up to 15% etc...
Is this possible?
Bookmarks