ok, I'e been looking all over for a way to do this formula, and I haven't
been successful yet. Hopefully someone can help me out, or at least point me
in the right direction.

The form I am creating is for use by various companies, it is for blank
printout, as well as entering data into it to receive calculations.

D6 is sq ft, D7 is Height, and D8 is a drop down list that 1-4 can be
selected in. The formula resides in cell H7

the formula is pretty simple, in itself- D6*D7/X . Where it gts interesting
is the following add-ons I'd like to put in it:

Roundup to the nearest integer, and if there is no data, than H7 remains
blank, also, the value of X depends upon what is selected in D8, basically if
d8=1,x=100 if d8=2 than x=50, if d8=3 than x=40, and if D8=4 than x=50.

If anyone can help out, I'd really appreciate it, since I have another
similiar formula that would need to follow the same requirements above.

Thanks for any help