Previous Topic Next Topic

PROBLEM IN EXCL

Closed
SACHIN0501
Posts
1
Registration date
Wednesday December 17, 2014
Status
Member
Last seen
December 17, 2014
 - Dec 17, 2014 at 09:46 AM
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
 - Dec 17, 2014 at 01:03 PM
=IF(Y9="adgaon kh","channi",IF(Y9="ambasi","channi",IF(Y9="changefal","channi",IF(Y9="channi","channi",IF(Y9="charangaon","channi",IF(Y9="chatari","channi",IF(Y9="chinchkhed sasti","channi",IF(Y9="digras bk","channi"))))))))

WHAT CAN I DO FOR ADDING MORE STAPES
OR HOW CAN I SHORT THIS FORMULA
Related:

1 reply

Answer 1 / 1
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
 147
Dec 17, 2014 at 01:03 PM
SACHIN0501, Good afternoon.

My suggestion for you is to use a small table instead of multiple ifs.

Take a look at an example I did for you:
http://speedy.sh/ATa47/17-12-2014-en-Kioskea-Multiple-IFs-OK.xlsx

Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0