AnsweredAssumed Answered

Need Help Converting Excel formula to Filemaker

Question asked by galeton on Nov 4, 2012
Latest reply on Feb 12, 2015 by micagordon

Title

Need Help Converting Excel formula to Filemaker

Post

     Good morning. I found a formula for Excel that converts an ISBN 13 number to ISBN 10 that I would love to implement in my database. But I don't know that much about formulas and wondered if someone might be able to help me convert this excel formula to work with filemaker.

      =SUBSTITUTE(TRIM(SUBSTITUTE(MID(A2,4,LEN(A2)-4),"-"," "))," ","-")&IF(MID(A2,LEN(A2)-1,1)="-","-","")&SUBSTITUTE(MOD(990-SUMPRODUCT((11-ROW($1:$9))*MID(MID(SUBSTITUTE(A2,"-",""),4,9),ROW($1:$9),1)),11),10,"X")

     This would take an ISBN 13 number like 9780393040029 and convert it to 0309304002X 

     Thank you for your help.

      

Outcomes