Example: A1 * B1 = C1 & D1 & E1 & F1 & G1 & H1 & I1 & J1 & K1 & L1 = $234567 The number of digits of the calculation results of the two cells is variable, which is arranged from one digit to ten million digits respectively, with a limit of 10 digits. A currency symbol is displayed in the cell before the highest digit, and no significant number in front of the currency symbol is displayed as a space

Example: A1 * B1 = C1 & D1 & E1 & F1 & G1 & H1 & I1 & J1 & K1 & L1 = $234567 The number of digits of the calculation results of the two cells is variable, which is arranged from one digit to ten million digits respectively, with a limit of 10 digits. A currency symbol is displayed in the cell before the highest digit, and no significant number in front of the currency symbol is displayed as a space


Always integer?
=LEFT(RIGHT(" $"&$A1*$B1,13-COLUMN()))
If there are two decimal places
=LEFT(RIGHT(" $"&$A1*$B1*100,13-COLUMN()))



In Excel, when A1 = 1, C1 = B1, D1, E1, F1, G1 are all equal to 0. When A1 = 2, D1 = B1, C1, E1, F1, G1 are all equal to 0
Next:
When A1 = 3, E1 = B1, C1, D1, F1 and G1 are all equal to 0. When A1 = 4, F1 = B1, C1, D1, E1 and G1 are all equal to 0. When A1 = 5, G1 = B1, C1, B1, D1 and F1 are all equal to 0
In Excel, when A1 = 1, C1 = B1, D1, E1, F1 and G1 are all equal to 0; when A1 = 2, D1 = B1, C1, E1, F1 and G1 are all equal to 0; when A1 = 3, E1 = B1, C1, D1, F1 and G1 are all equal to 0; when A1 = 4, F1 = B1, C1, D1, E1 and G1 are all equal to 0; when A1 = 5, G1 = B1, C1, B1, D1 and F1 are all equal to 0


Select C1: G1
input
=IF(COLUMN()-2=$A1,$B1,0)
Enter and press Ctrl + enter
For your example only, you can use this formula



A1*B1+C1*D1+E1*F1+G1*H1+I1*J1+K1*L1+M1*N1+O1*P1+… How to calculate it * IU by formula
Is there a ready-made function formula


=sumproduct(mod(column(A:IT),2)*A1:IT1*B1:IU1)



How to write the formula in excel? When A1 * B1 is zero, E1 = C1 * D1; when A1 * B1 and C1 * D1 are both zero, E1 = F1 * H1; otherwise, E1 = A1 * B1


=if(or(a1=0,b1=0),c1*d1,if(or(c1=0,d1=0),f1*h1,a1*b1))