خرید بک لینک

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??

- - , .
.

برچسب: نویسنده: استخدام کار تاريخ: چهارشنبه 23 تير 1395 ساعت: 9:52

صفحه بندی