Code

[alliswell]

ROYALKINGS where
R=1,O=2,Y=3,A=4,L=5,K=6,I=7,N=8,G=9,S=0
Now whenever i type any code for example when i put YLS in a1 i should get 350 in b1 coz y=3, L=5, s=0
I dont want macro. Some formula function or trick.

Thanks n regards
Love u all

 

[Fluff]

As that is a significantly different question it needs a new thread. Thanks

 

[Peter_SSs]

As that is a significantly different question it needs a new thread.

@alliswell
I think that it is already being covered during this existing thread, so please do not start yet another one on the same topic.

 

[alliswell]

@alliswell
I think that it is already being covered during this existing thread, so please do not start yet another one on the same topic.

Ok fluff thanks.