array of data and nested bits
 

Howdy,

I have two variables (width & Height) which determine a final costing.
Initially I tried nested IF statements but I have too many possibilities
(total of 30 outcomes). I then tried -

If Width 1 yes Lookup (Heights 1-5)
no if Width 2 yes Lookup (Heights 1-5)
no if Width 3 yes (lookup heights 1-5)

Its here that things start to fall apart, the equation doesn't look past the
second IF statement to acknowledge Width 3. The syntax seems correct, Excel
corrected it to make it so but the bugger just doesn't work

array of data and nested bits
 

Is this actual code? excel or VBA?

--
__________________________________
HTH

Bob

"Alqemyst" wrote in message
...
Howdy,

I have two variables (width & Height) which determine a final costing.
Initially I tried nested IF statements but I have too many possibilities
(total of 30 outcomes). I then tried -

If Width 1 yes Lookup (Heights 1-5)
no if Width 2 yes Lookup (Heights 1-5)
no if Width 3 yes (lookup heights 1-5)

Its here that things start to fall apart, the equation doesn't look past
the
second IF statement to acknowledge Width 3. The syntax seems correct,
Excel
corrected it to make it so but the bugger just doesn't work