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

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

Thanks!

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

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