Formula help for Conditional Statements

[mdahlhausen]

Hello 

I try to create a IF formula without success. Can someone help me please.

I have a shared parameter in my title block which has the text, for instance, B1.

I would like that an other field will translate this B1 to 10, B2 to 11, B2 to 12 and shows that in the titleblock.

It would be in total 25 letter/numbers (all fixed) which should be translated into two digits.

Please no Dynamo suggestions, this should happen without running a script.

Thank you

[ToanDN]

You cannot use Text parameters to drive a formula. Can you use an Integer
parameter with B as a prefix for label? Then, you can create a formula
using = integer param + 9.

[barthbradley]

I'm not clear what you are doing.

You have a titleblock parameter, that is currently populated with a value, in your Project -- and you want to change all those values via a formula? 

You can't.  

[mdahlhausen]

I have a parameter in the titleblock which is, for instance B1, we now have an additional parameter, which should be two numbers. It is not a one off translation, but a permanent requirement. Each time a new sheet is created and filled in with the letter / number, the second parameter should automatically be filled in. This is always a number. This is to avoid human error when filling in the titleblock.