View original (French)

Price per liter formula based on volume and price

Solved
sanjus Posted messages 3 Status Member -  
lecristal Posted messages 961 Registration date   Status Member Last intervention   -
Hello,
I’m terrible at Excel!
I have a table with liquid products that I buy in different sizes.
- In the first column, I have the size (0.25l, 0.5l, or 1l)
- In the second column, I have the price of the product
- I would like to enter a formula in the third column to calculate, based on the size in the first column and the price in the second column, the price per liter.
Since the sizes are different in the first column, I can’t just do a simple multiplication.

I imagine someone might have an idea to propose, it would be really nice if they took the time to help me!

Thank you all.

3 answers

  1.
    PHILOU10120 Posted messages 6463 Registration date   Status Contributor Last intervention   835
     
    Hello

    You must take the value, divide it by the container in liters (.25, .50, 1)
    and multiply by 100

    =B1/A1*100

    --
    Practice makes perfect. - It's when you're up against the wall that you see the bricklayer - one always learns from their mistakes.
    33
    1. lecristal Posted messages 961 Registration date   Status Member Last intervention   18
       
      Thank you for your formula
      have a nice day to you
      0