Simple Division Formula Help

I’m not good with formulas. Can I get some quick help, please?

This formula…
({Material Length}/{Product Length})/{Purchase Cost}

With these values in their respective columns…
Material Length - 48
Product Length - 16
Purchase Cost - $39.99

Gives me a cost per product result of…
$.08

The result should be $13.33. What am I doing wrong?

Precisely. :wink:

Because, 48 / 16 = 3…
And, 3 / 39.99 = 0.075

I think you want:

{Purchase Cost} / ({Material Length} / {Product Length})

Ergo…

39.99 / (48 / 3) == 13.33

1 Like

This feels like we are trying to write a formula for a word problem without seeing the actual word problem.

There are several different formulas that will produce the number that you want. For example, the following formula will also produce 13.33:

({Product Length} / {Material Length}) * {Purchase Cost} 

However, you should use a formula that best represents the original word problem. This will make maintenance easier later on.

Without knowing more about the original problem, it looks like you have purchased 48" inches of some material for $39.99. You want to use 16" of that material to create a product. You want calculate the cost of your product, so you need to see how much the 16" costed.

With that in mind, I would use the following formula which multiplies the amount of material that you are using times the unit cost of the material.

{Product Length} * ( {Purchase Cost} / {Material Length} ) 

Notice that all three of the formulas (@Bill.French’s formula and the two I present in this post) will all product the exact same result. You are free to use whichever one makes the most sense to you and will be the easiest to maintain. If I am totally wrong about your original word problem and none of the formulas make sense to you, feel free to post it and we can see if we can come up with a different formula that makes sense to you.

1 Like

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.