Round up or down to a multiple of 5

  • Thread starter Thread starter latincutiepie
  • Start date Start date
L

latincutiepie

I have a question. Im trying to come up with a formula that should say:

the total of a whole number times 1.15 and then round it off to either a 0 or
a 5.

Can someone please help me!
 
=ROUND((A1*1.15)/5,0)*5

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Try MROUND function. It returns the nearest multiple of choice.

Use parameter 5 to return 0 or 5.

=MROUND(1.15*8 , 5) returns 10
 
Thank you sooooo much...I was racking my brain for hours yesterday and this
is the formula that actually worked...yeaaayyyyy!!! Thanks again.

Bob said:
=ROUND((A1*1.15)/5,0)*5
I have a question. Im trying to come up with a formula that should say:
Click to expand...
[quoted text clipped - 3 lines]
Can someone please help me!
Click to expand...
Click to expand...
 
Back
Top