Help me on this formula to shorten

[Closed]
Report
Posts
27
Registration date
Tuesday November 18, 2014
Status
Member
Last seen
May 21, 2015
-
Posts
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 2021
-
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

Posts
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 2021
145
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month