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
|