#### Jagat Pavasia

##### Board Regular
 A B C D E F 25 10 0 250 60 125 7 500 100 336 33 600 369.25 1425 526 181

<tbody>
</tbody>

I want A x B = answer in two raw ( last 3 digit n "F" and first any amount digit in "E")

what can i do ?

pls help me

### Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

#### shg

##### MrExcel MVP
 a​ b​ c​ d​ e​ f​ g​ h​ 1​ ​ ​ ​ ​ ​ ​ ​ ​ 2​ 25​ 10​ 0​ 250​ e2: =int(a2*b2/1000) 3​ 60​ 125​ 7​ 500​ f2: =mod(a2*b2, 1000) 4​ 100​ 336​ 33​ 600​ 5​ 369.25​ 1425​ 526​ 181.25​

#### Jagat Pavasia

##### Board Regular
 a​ b​ c​ d​ e​ f​ g​ h​ 1​ 2​ 25​ 10​ 0​ 250​ e2: =int(a2*b2/1000) 3​ 60​ 125​ 7​ 500​ f2: =mod(a2*b2, 1000) 4​ 100​ 336​ 33​ 600​ 5​ 369.25​ 1425​ 526​ 181.25​

<tbody>
</tbody>

thank you for nice response..

but when i multiply 25 x 1000 then answer is on E2 is "25" and F2 have only "0", ( I want "000" in F2)

and if i multiply 25 x 10000 , then E2 = "250" and F2 = "000"

please update it and give me new formula

#### AlanY

##### Well-known Member
try, format cells in column F as Custom > type > 000

#### Excel777

##### Well-known Member
try, format cells in column F as Custom > type > 000

ABCDEF
125100250
2601257500
310033633600
4369.251425526181
525100025000

</tbody>
Sheet2

Worksheet Formulas
CellFormula
E1=INT(A1*B1/1000)
F1=ROUND(MOD(A1*B1, 1000),0)

</tbody>

<tbody>
</tbody>
Thanks for INT formula new for me

Replies
12
Views
146
Replies
3
Views
59
Replies
2
Views
40
Replies
5
Views
52
Replies
17
Views
531