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
>