formula help

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

=IF(H7="","",ROUND((D6*D7)/(LOOKUP(D8,{1,2,3,4;100,50,40,50})),1))

"-Bryan" wrote:

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

Wow! Thanks! I did change the H7 reference to D7(kept telling me circular
reference), but great formula. It helps me a lot to understand how it is
constructed. The one question I have, what is the final ",1" in the formula
for?

"Joel" wrote:

=IF(H7="","",ROUND((D6*D7)/(LOOKUP(D8,{1,2,3,4;100,50,40,50})),1))

"-Bryan" wrote:

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

This portion is a simple lookup. Looks up 1,2,3,4 and respectively returns
100,50,40,50.

LOOKUP(D8,{1,2,3,4;100,50,40,50})

The final One is part of the Round function which say to round to 1 decimal
point.

"-Bryan" wrote:

Wow! Thanks! I did change the H7 reference to D7(kept telling me circular
reference), but great formula. It helps me a lot to understand how it is
constructed. The one question I have, what is the final ",1" in the formula
for?

"Joel" wrote:

=IF(H7="","",ROUND((D6*D7)/(LOOKUP(D8,{1,2,3,4;100,50,40,50})),1))

"-Bryan" wrote:

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

Again, thank you very much. It's been almost exactly ten years since I've
had to work in excel, and every bit of info helps me get back into the swing
of things.


"Joel" wrote:

This portion is a simple lookup. Looks up 1,2,3,4 and respectively returns
100,50,40,50.

LOOKUP(D8,{1,2,3,4;100,50,40,50})

The final One is part of the Round function which say to round to 1 decimal
point.

"-Bryan" wrote:

Wow! Thanks! I did change the H7 reference to D7(kept telling me circular
reference), but great formula. It helps me a lot to understand how it is
constructed. The one question I have, what is the final ",1" in the formula
for?

"Joel" wrote:

=IF(H7="","",ROUND((D6*D7)/(LOOKUP(D8,{1,2,3,4;100,50,40,50})),1))

"-Bryan" wrote:

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