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

 

[Rick Rothstein]

So, is the 2.25 is a fixed constant or located in another cell somewhere?

 

[chunu]

So, is the 2.25 is a fixed constant or located in another cell somewhere?

Fixed, but you can use another cell.

 

[Rick Rothstein]

This should do it...

=INT(2.25*A1)+0.4*MOD(2.25*A1,1)

 

[chunu]

This should do it...

=INT(2.25*A1)+0.4*MOD(2.25*A1,1)

Thanks