More then 7 IF functions?
You can replace your formula with a much simpler VLOOKUP, and this will
allow you to have many more products. First of all set up a two-column
table somewhere (assume Y1 to Z30 on the same Sheet1). In column Y you
would enter '010, '015, '020, '030 etc down the column, and in column Z
you would have product A, product B, product C etc adjacent to the
codes.
Then your formula can be replaced with this one:
=VLOOKUP(C4,Y$1:Z$30,2,0)
This takes the value in C4 and sees if there is an exact match in the
first column of the table Y1:Z30 - if there is it then returns the
value which is in the second column of the table (this is the parameter
2 in the formula). If there is not an exact match the formula returns
the #N/A error.
Hope this helps.
Pete
|