array of data and nested bits

  • Thread starter Thread starter Alqemyst
  • Start date Start date
A

Alqemyst

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
 
Back
Top