View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default 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