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
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
WHAT CAN I DO FOR ADDING MORE STAPES
OR HOW CAN I SHORT THIS FORMULA
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Dec 17, 2014 at 01:03 PM
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
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
