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 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - 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

1 response

Answer 1 / 1
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 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