Hello all! Newbie here
I am a small bussiness owner working with resin and I am trying to use excel to make a worktable that auto calculates the costs of whatever amount of resin I am using at a given time, for each resin I use.
I do that manually atm by using the rule of three: multiplying the grams of resin I am currently using with the total cost of the resin I bought and dividing that by the weight of the total resin I bought.
So I have a column for grams I want to use, a column for cost per gram and I added a line for total cost and package size trying to make my own simple formula. Simply typed =D2*B4/C2 and voila. But I still have to manually type that every time and figure out which tile is which and honestly I am trying to make a simpler automated way of doing all this and that is just not easier at all.
Please help I have no idea what I am doing here

Untitled.png