Taking the Decimal Part as an Integer Number without being calculated as decimal in Excel

Question

I am sorry if the ans is available already but i tried finding and could't after spending much time. I am stuck in a very small issue.

The Problem is just like a math problem I purchase different items with different packing qty

if i purchase pack of biscuit with 20 box in a carton i received 10 carton and 15 box

I want to put the number in an excel cell as 10.15 and i want it to calculate it as 10+(15/20)*Rate

i tried

    A       B              C           D
  1 Rate    Packing qty    Received    Bill Amount
  2 100     20             10.15       =G6*(INT(H6)+((MOD(H6,1)/C1)))

but could not get the required results. Any one guide me how to resolve this issue.

Answer 1

You can utilize

=(INT(C2)+ MOD(C2,1)*100/B2)*100