IF formula problem

  • Thread starter Thread starter Wim
  • Start date Start date
W

Wim

I need to add categories to a downloaded bank statement. I would use
something like Pascal's CASE formula:
CASE(lookup value)=
a: do x
b: do y
c: do z
etc...

Excel doesn't have such formula. Therefore, I use the following nested
IF formula:
=IF(ISERROR(SEARCH('Netbank Cat
names'!$A$2,B73)),IF(ISERROR(SEARCH('Netbank Cat
names'!$A$3,B73)),IF(ISERROR(SEARCH('Netbank Cat
names'!$A$4,B73)),IF(ISERROR(SEARCH('Netbank Cat
names'!$A$5,B73)),IF(ISERROR(SEARCH('Netbank Cat
names'!$A$6,B73)),IF(ISERROR(SEARCH('Netbank Cat
names'!$A$7,B73)),"",'Netbank Cat names'!$B$7),'Netbank Cat
names'!$B$6),'Netbank Cat names'!$B$5),'Netbank Cat
names'!$B$4),'Netbank Cat names'!$B$3),'Netbank Cat names'!$B$2).

where:
Column B = the description of the bank transfer
'Netbank Cat names'!A2 to A7 = the Cat Names
'Netbank Cat names'!B2 to B7 = the Alternative Cat Names


However, Excel does not allow me to add a 7th "IF".... Am I limited to
6 nested "IF"s in a formula?. Any alternatives to such formula

Wim
Durban
MS Office 2003 Excel SP1
 
However, Excel does not allow me to add a 7th "IF".... Am I limited to
6 nested "IF"s in a formula?.
Click to expand...

Actually, the limitation is 7 nested functions (of any type, not just IF).
Any alternatives to such formula
Click to expand...

Check HELP for VLOOKUP or HLOOKUP



--ron
 
Back
Top