Round up or down to a multiple of 5

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

latincutiepie - 05 Mar 2008 22:24 GMT

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!

Reply to this Message

Bob Phillips - 05 Mar 2008 22:34 GMT

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

Signature

---
HTH

Bob

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

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

Reply to this Message

latincutiepie - 06 Mar 2008 13:45 GMT

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
>
[quoted text clipped - 3 lines]
>>
>> Can someone please help me!

Reply to this Message

Henn Sarv - 05 Mar 2008 22:37 GMT

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

or this modifications :)

Henn

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

Reply to this Message

Dave Peterson - 05 Mar 2008 22:40 GMT

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

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

Signature

Dave Peterson

Reply to this Message

OssieMac - 06 Mar 2008 11:07 GMT

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

Signature

Regards,

OssieMac

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

Reply to this Message

Rate this thread: