Formula pricing not working for variations

I'm dealing with different products variations with very different pricing sometimes. Let's say I have a product with two variations, one costs $10, the other $100. The product is listed for $10.

I set a formula for $10 to be multiplied by 2, and for $100 to be multiplied by 1.5.

The end result should be that the product variations should cost $20 and $150, but apparently the pricing formula disregards variations and only deals with the main price (usually the lowest price), so the variations cost $20 and $200.

This makes it very hard to work with products with very different variations. Is this a known issue? I hope this could be fixed, been working for hours to figure out why the formula doesn't work.