hello all,
i need a formula that helps me to make a number in a multiple of 5. i used MROUND, but this formula rounds to a nearest multiple of 5. is there any posibility to obtain the next multiple of 5, for example i need the number 912 to become 915, and not 910.
can anyone help me?
thank you very much
Last edited by adriana; 10-31-2011 at 12:49 AM.
Hi and welcome to the board
try = CEILING(A1,5)
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
thank you very, very much. this was the answer to my problem. this forum is great!Originally Posted by arthurbr
You're welcome
It would also be nice if you paid attention to the remarks in my sig
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
ok.sorry. i didn't realise.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks