please help me

Jagat Pavasia

Board Regular
Joined
Mar 9, 2015
Messages
208
Office Version
  1. 2019
Platform
  1. Windows
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
 

Some videos you may like

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
Joined
May 7, 2008
Messages
21,770
Office Version
  1. 2010
Platform
  1. Windows
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
Joined
Mar 9, 2015
Messages
208
Office Version
  1. 2019
Platform
  1. Windows
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
Joined
Oct 30, 2014
Messages
4,159
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. Windows
try, format cells in column F as Custom > type > 000

<b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: rgb(218,231,245);text-align: center;color: rgb(22,17,32)"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th></tr></thead><tbody><tr ><td style="color: rgb(22,17,32);text-align: center;">1</td><td style="text-align: right;;">25</td><td style="text-align: right;;">10</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;background-color: #E2EFDA;;">0</td><td style="text-align: right;background-color: #E2EFDA;;">250</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">2</td><td style="text-align: right;;">60</td><td style="text-align: right;;">125</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;background-color: #E2EFDA;;">7</td><td style="text-align: right;background-color: #E2EFDA;;">500</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">3</td><td style="text-align: right;;">100</td><td style="text-align: right;;">336</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;background-color: #E2EFDA;;">33</td><td style="text-align: right;background-color: #E2EFDA;;">600</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">4</td><td style="text-align: right;;">369.25</td><td style="text-align: right;;">1425</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;background-color: #E2EFDA;;">526</td><td style="text-align: right;background-color: #E2EFDA;;">181</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">5</td><td style="text-align: right;;">25</td><td style="text-align: right;;">1000</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;background-color: #E2EFDA;;">25</td><td style="text-align: right;background-color: #E2EFDA;;">000</td></tr></tbody></table><p style="width:4.8em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid rgb(187,187,187);border-top:none;text-align: center;background-color: rgb(218,231,245);color: rgb(22,17,32)">Sheet2</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: rgb(255,255,255)" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: rgb(255,255,255);border-collapse: collapse; border-color: rgb(187,187,187)"><thead><tr style=" background-color: rgb(218,231,245);color: rgb(22,17,32)"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">E1</th><td style="text-align:left">=INT(<font color="Blue">A1*B1/1000</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">F1</th><td style="text-align:left">=ROUND(<font color="Blue">MOD(<font color="Red">A1*B1, 1000</font>),0</font>)</td></tr></tbody></table></td></tr></table><br />
 

Excel777

Well-known Member
Joined
Jul 3, 2009
Messages
866
try, format cells in column F as Custom > type > 000

ABCDEF
125100250
2601257500
310033633600
4369.251425526181
525100025000

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet2

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

<thead>
</thead><tbody>
</tbody>

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

Watch MrExcel Video

Forum statistics

Threads
1,108,751
Messages
5,524,616
Members
409,595
Latest member
therevford

This Week's Hot Topics

Top