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" wrote in message
...
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