Outstanding! Thank you very much. I am now able to complete my project.

"JLatham" wrote:

I think the easiest way to solve this problem is going to be for you to set
up a lookup table with your associated values in it and then use VLOOKUP()
inside of an IF() statement to pick your choices. This is difficult to
explain in words, so I prepared an example workbook which you can get at:
http://www.jlathamsite.com/uploads/v..._Loudmouth.xls

your formula in the cell where you're trying to build it now is going to
look something like
=IF(B40,VLOOKUP(H4,H9:I16,2,True),VLOOKUP(H4,H9:J 16,3,True))

The ranges mentioned, H9:I16 and H9:J16, will need to be changed to match
the range you set up in the real world.

A couple of things to note, the list must be in ascending order from top to
bottom based on your to-match values (399, 349, etc) in order for it to work
properly and reliably. The lookup matrix does not have to be on the same
sheet, you just have to be sure and reference the lookup range correctly.
For more information, look for VLOOKUP under Excel Help. I hope this helps
some.

"Loudmouth" wrote:

This formula works:
=IF(B40,IF(H4399,1.4,IF(H4349,1.25,IF(H4299,1. 05,IF(H4249,0.9,IF(H4199,0.7,IF(H4149,0.55,
IF(H4124,0.45)))))),IF(H4349,1,IF(H4299,0.85,IF (H4249,0.7,IF(H4199,0.55,IF(H4149,0.45,IF(H412 4,0.35,0)))))))

This formula does not, why?
=IF(B40,IF(H4 449, 1.6,
IF(H4399,1.4,IF(H4349,1.25,IF(H4299,1.05,IF(H4 249,0.9,IF(H4199,0.7,IF(H4149,0.55,
IF(H4124,0.45))))))),IF(H4349,1,IF(H4299,0.85,I F(H4249,0.7,IF(H4199,0.55,IF(H4149,0.45,IF(H41 24,0.35,0)))))))