Need formula for: If A or B, then populate Left Initial, Right Initial, System number, and enough zeros to total 10 values

I need to tweak the below formula, so that instead of always adding 5 zeros, add enough zeros to equal 10 values. I'm using this in a system (iCIMS), and the result (depending on the status of specific people, ie. A1 and A2 in this mock) needs to be first initial, left initial, system id, with enough zeros to equal 10 values.

Example: Kiki James System id: 123 Result: KJ12300000 Example: Bob Jones System id: 2345 Result: BJ23450000

The below was working for awhile, however now the system id's have grown to 4 digits (so some folks have 3 digits and some 4).

IF(OR(A1="yes",A2="yes),Left(B1)&Left(B2)&B3&"00000","")

Any help??

- - , .
.

Recent Questions...