The Formula to Multiply Decimal in Excel

Hello.. anyone who can help me, please.
I want multiply the number that contains decimal, like this :
12.26, and here I want multiply 12 with 1000, and then 26 multiply with 50

12.26

==> 12 x 1000 = 12000
==> 26 x 50 = 1300
-------
so, the result is : 13300
======

Thank's b 4

if you have 12.26 in A1, then:
in B1: =INT(A1) , gives you the integer portion, 12 in this case and,
in C1: =B1-A1 gives you the fractional portion, namely 0.46. So, to multiply the
two portions, just say,
B1: =INT(A1) * 1000,
C1: =(A1-INT(A1))*50

Originally Posted by antoni

Hello.. anyone who can help me, please.
I want multiply the number that contains decimal, like this :
12.26, and here I want multiply 12 with 1000, and then 26 multiply with 50

12.26

==> 12 x 1000 = 12000
==> 26 x 50 = 1300
-------
so, the result is : 13300
======

Thank's b 4

Assuming cell A1 contains 12.26
In result cell, you type this formula:

PHP Code: 

=INT(A1)*1000+(A1-INT(A1))*5000 


OR, it means:

PHP Code: 

=INT(A1)*950+A1*5000