Shorten long IF statement.

  • Thread starter Thread starter lukus2005
  • Start date Start date
L

lukus2005

I'm looking for a way to shorten a long IF statement.

Column A: contains a pulldown with 5 possible duct types (ie: Grease,
Rectangular, Round, etc...)
Column B: is the width of the duct.
Column C: is the height of the duct.
Column F: quantity of ductwrap required based on duct type and
measurements.

I was hoping to enter my 5 different formulas somewhere in my
spreadsheet (out of sight) and have a nested IF statement making
reference to the appropriate hidden cell to retrieve the correct
formula instead of having a super long formula.

The problem is that my page will allow up to 20 different ducts
(lines) to be entered (estimating spreadsheet) so the cell reference
in my formulas cannot be hard-coded. In other words, each time I enter
a new duct size on a new row, my formula must update in order to refer
to the correct row.
 
You may not need 5 formulas where one may do using INDIRECT. Much more
detail or
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.
 
Back
Top