I want 2 add some long values with

March 26, 2011 at 03:18:52
Specs: Windows XP
I want 2 add some long values with "IF Statement" because I have 100 names of Branched and want to add with Code numbers of Branches e.g.

=IF(A7=2,"Main Branch Karachi",IF(A7=3,"NBP Airport Branch",IF(A7=7,"NBP Custom House Branch",IF(A7=9,"NBP DHS Branch",IF(A7=10,"NBP Denso Hall Branch", IF(A7=12,"NBP Fish Harbour Branch", IF(A7=18,"NBP Aimai House Branch", IF(A7=27,"NBP M.A.Jinnah Road Branch", IF(A7=28,"NBP Malir Cantt. Branch", IF(A7=32,"NBP PAF Masroor Branch", IF(A7=42,"NBP Nazimabad Branch", IF(A7=44,"NBP Nicol Road Branch", IF(A7=48,"NBP PECHS Branch", IF(A7=49,"NBP PIB Colony Branch", IF(A7=50,"NBP PIDC House Branch", IF(A7=55,"NBP Saddar Branch", IF(A7=64,"NBP SITE Branch", IF(A7=71,"NBP Karachi University Branch","Error")))))))))

But error of "nested formla in this file" occurs.
What to do?

See More: I want 2 add some long values with

Report •

March 26, 2011 at 04:21:17
Let's assume that you are talking about Excel.

You can only have 7 or less nested IFs in Excel. If you need more choices then you need to write a VBA macro (see this article) or else use the LOOKUP function in conjunction with a Table.

If you are not talking about Excel then it would help to specify the program you are using.

Report •

March 26, 2011 at 12:03:33
Maybe use a lookup.

Report •

March 28, 2011 at 02:42:12
Thanx Bro. But it works in Numberic Value not in Text Values.

Report •

Related Solutions

March 28, 2011 at 18:05:34
Set up an array, such as:

Report •

Ask Question