How to Round up to nearest whole number at a specific decimal?

I have been bouncing this around a few days and I can't seem to get it.

What I need is a formula that will round a cell up to the next whole number
at a specified decimal, and down below that decimal.

example

A1=480
B1=A1/350 - Result = 1.3714...

I need this example to round up at 0.1428 and down at 0.1427, in this case
result would be "2"

Thanks in advance

trpost,

I believe this formula does what you want:

=IF(MOD(A1/350,1)>=0.1428,ROUNDUP(A1/350,0),INT(A1/350))

the Mod function in this case returns the decimal portion of the number
(there may be a more direct function, I'm not sure).

hth,

Doug

"trpost" <trpost@discussions.microsoft.com> wrote in message
news:CBEAC7BA-01FE-4B40-8658-82CBA3F736D4@microsoft.com...
> I have been bouncing this around a few days and I can't seem to get it.
>
> What I need is a formula that will round a cell up to the next whole
number
> at a specified decimal, and down below that decimal.
>
> example
>
> A1=480
> B1=A1/350 - Result = 1.3714...
>
> I need this example to round up at 0.1428 and down at 0.1427, in this case
> result would be "2"
>
> Thanks in advance
>

You, My good man are a Lifesaver!!!

I am kinda new to this excel stuff and you just made look so freakin cool
tomorrow when I go into the office with this solved!

Thanks,
Travis

"Doug Glancy" wrote:

> trpost,
>
> I believe this formula does what you want:
>
> =IF(MOD(A1/350,1)>=0.1428,ROUNDUP(A1/350,0),INT(A1/350))
>
> the Mod function in this case returns the decimal portion of the number
> (there may be a more direct function, I'm not sure).
>
> hth,
>
> Doug
>
> "trpost" <trpost@discussions.microsoft.com> wrote in message
> news:CBEAC7BA-01FE-4B40-8658-82CBA3F736D4@microsoft.com...
> > I have been bouncing this around a few days and I can't seem to get it.
> >
> > What I need is a formula that will round a cell up to the next whole
> number
> > at a specified decimal, and down below that decimal.
> >
> > example
> >
> > A1=480
> > B1=A1/350 - Result = 1.3714...
> >
> > I need this example to round up at 0.1428 and down at 0.1427, in this case
> > result would be "2"
> >
> > Thanks in advance
> >
>
>
>

Thanks!

"trpost" <trpost@discussions.microsoft.com> wrote in message
news:A8041215-2422-4ED5-8A08-263E11001C09@microsoft.com...
> You, My good man are a Lifesaver!!!
>
> I am kinda new to this excel stuff and you just made look so freakin cool
> tomorrow when I go into the office with this solved!
>
> Thanks,
> Travis
>
> "Doug Glancy" wrote:
>
>> trpost,
>>
>> I believe this formula does what you want:
>>
>> =IF(MOD(A1/350,1)>=0.1428,ROUNDUP(A1/350,0),INT(A1/350))
>>
>> the Mod function in this case returns the decimal portion of the number
>> (there may be a more direct function, I'm not sure).
>>
>> hth,
>>
>> Doug
>>
>> "trpost" <trpost@discussions.microsoft.com> wrote in message
>> news:CBEAC7BA-01FE-4B40-8658-82CBA3F736D4@microsoft.com...
>> > I have been bouncing this around a few days and I can't seem to get it.
>> >
>> > What I need is a formula that will round a cell up to the next whole
>> number
>> > at a specified decimal, and down below that decimal.
>> >
>> > example
>> >
>> > A1=480
>> > B1=A1/350 - Result = 1.3714...
>> >
>> > I need this example to round up at 0.1428 and down at 0.1427, in this
>> > case
>> > result would be "2"
>> >
>> > Thanks in advance
>> >
>>
>>
>>

Try the roundup() and rounddown() functions.

"trpost" wrote:

> I have been bouncing this around a few days and I can't seem to get it.
>
> What I need is a formula that will round a cell up to the next whole number
> at a specified decimal, and down below that decimal.
>
> example
>
> A1=480
> B1=A1/350 - Result = 1.3714...
>
> I need this example to round up at 0.1428 and down at 0.1427, in this case
> result would be "2"
>
> Thanks in advance
>