array of data and nested bits

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Page numbering with Merged Document and IF statements 1
VLOOKUP & Data Validation 0
Return a value from one column using an array and a single row 1
Excel 2000 formula to dynamically sum adjacent rows and columns whererows inserted/deleted 3
Can I name a column and use it in a formula? (Excel 2007) 6
Help! -How to compare two worksheets; multiple rows of data=result 1
Count if data falls within a range AND that has a certain criteria 1
How to create a dynamic table based on a set of other nested attributes 0

Top