Is RoundUp the right path?

[geno32080]

Okay I got the if formula taken care of, Thank you. The next hurtle is to be able to round up. Cell C3 =24. Cell D3 divides 24/200. The 24 is the individual quantity needed and 200 is the case quantity. I've tried a few different methods. I need the returned result to be 1 no decimal.
The formula I tried in D3 is =ROUNDUP(C3/200,1). It returns zero.
I'm stuck, any one have an Idea?
Thank you for reading my post.

 

[6StringJazzer]

You are telling it to round up to the next highest number to one decimal place, that next, you are rounding up to the next highest multiple of 0.1. To round up to the next highest integer use

=ROUNDUP(C3/200,0)

 

[geno32080]

You are telling it to round up to the next highest number to one decimal place, that next, you are rounding up to the next highest multiple of 0.1. To round up to the next highest integer use

=ROUNDUP(C3/200,0)

Yep, that's the ticket. I tried all sorts of combo's, 0 never crossed my mind..
Thank you sir. Once again this site rules!!