View original (French)

Price per liter formula based on volume and price

Solved
sanjus Posted messages 3 Status Membre -  
lecristal Posted messages 961 Registration date   Status Membre 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 réponses

Réponse 1 / 3
PHILOU10120 Posted messages 6463 Registration date   Status Contributeur Last intervention   833
 
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
lecristal Posted messages 961 Registration date   Status Membre Last intervention   18
 
Thank you for your formula
have a nice day to you
0