Previous Topic Next Topic

PROBLEM IN EXCL

Closed
SACHIN0501 Posts 1 Registration date Wednesday 17 December 2014 Status Member Last seen 17 December 2014 - 17 Dec 2014 à 09:46
Mazzaropi Posts 1985 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 17 Dec 2014 à 13:03
=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

1 response

Réponse 1 / 1
Mazzaropi Posts 1985 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
17 Dec 2014 à 13:03
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