Help me on this formula to shorten

Closed
mathewmunna Posts 27 Registration date Tuesday November 18, 2014 Status Member Last seen May 21, 2015 - Nov 27, 2014 at 08:18 AM
Mazzaropi Posts 1965 Registration date Monday August 16, 2010 Status Contributor Last seen September 18, 2022 - Nov 28, 2014 at 06:17 AM
Hello,

please help me out to shorten this formula..

=IF(B53="SP1",2,IF(B53="SP2",2,IF(B53="SP3",2,IF(B53="SP4",2,IF(B53="SP5",2,0)))))+IF(B54="SP1",2,IF(B54="SP2",2,IF(B54="SP4",2,IF(B54="SP4",2,IF(B54="SP5",2,0)))))

1 reply

Mazzaropi Posts 1965 Registration date Monday August 16, 2010 Status Contributor Last seen September 18, 2022 146
Nov 28, 2014 at 06:17 AM
mathewmunna, Good morning.

I believe this question is the same already presented in another post.
It was already solved.

Take a look at:
https://ccm.net/forum/affich-779585-how-to-count-different-charecters#p779876

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