Multiply remainder only

[chunu]

Hi,
cell A1 is 3.36 multiply with 2.25 result in B1 is 7.56
In cell C1 , i want to multiply value after decimal (.56) with 40 result in C1 should be 7.22
Thanks

 

[Phuoc]

0.56*40 = 22.4 not 7.22

=MOD(B1,1)*40

 

[chunu]

0.56*40 = 22.4 not 7.22

=MOD(B1,1)*40

7.56 , I want to keep 7 as it is and multiply only 56 with 40 and round then the result should be 7.22

 

[Rick Rothstein]

I think this formula may be what you are looking for...

=INT(B1)+0.4*MOD(B1,1)

 

[chunu]

I think this formula may be what you are looking for...

=INT(B1)+0.4*MOD(B1,1)

Thanks

 

[Phuoc]

Another Option:

=DOLLARFR(B1,40)

 

[chunu]

Another Option:

=DOLLARFR(B1,40

Yes its working also
Thanks for your reply.

 

[chunu]

I think this formula may be what you are looking for...

=INT(B1)+0.4*MOD(B1,1)

Can we skip one step, like cell A1 3.36x2.25=7.56 then formula you gave and result in B1 instead of C1.
Thanks

 

[Rick Rothstein]

Are you saying that cell A1 contains this formula...

=3.36x2.25

so that 7.56 is displayed in cell A1? If so, just change the two B1's to A1's in my formula. If not, please clarify what you mean.

 

[chunu]

Are you saying that cell A1 contains this formula...

=3.36x2.25

so that 7.56 is displayed in cell A1? If so, just change the two B1's to A1's in my formula. If not, please clarify what you mean.

In cell A1 no formula i put value directly 3.36
I want formula in B1, Result should be 7.22,
Currently i am using 3 cell , i want to combine B1and C1
A1 Direct input 3.36
B1=3.36*2.25=7.56
C1=INT(B1)+0.4*MOD(B1,1)

Thanks