Round up or down to a multiple of 5

[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!

 

[Bob Phillips]

=ROUND((A1*1.15)/5,0)*5

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Henn Sarv]

try =ROUND(A1/5,0)*5

or this modifications

Henn

 

[Dave Peterson]

You may want to look at Excel's help for =ceiling() and =floor(), too.

 

[OssieMac]

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

 

[latincutiepie via OfficeKB.com]

Thank you sooooo much...I was racking my brain for hours yesterday and this
is the formula that actually worked...yeaaayyyyy!!! Thanks again.

=ROUND((A1*1.15)/5,0)*5

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

[quoted text clipped - 3 lines]

Can someone please help me!