加總 以字母所代表數 (13957)

C2=LEN(SUBSTITUTE(A2,"M",))*500+2^(SUMPRODUCT(N(MID(A2,{1;2;3},1)="M"))-1)*100-50

另解=LEN(SUBSTITUTE(A2,"M",))*500+CHOOSE(LEN(SUBSTITUTE(A2,"V",))+1,,50,150,350)

另解=LEN(SUBSTITUTE(A2,"M",))*500+2^(LEN(SUBSTITUTE(A2,"V",))-1)/1%-50



留言

  1. =(LEN(SUBSTITUTE(A2,"M",))*10+2^LEN(SUBSTITUTE(A2,"V",))-1)*50

    回覆刪除

張貼留言