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