Hello, I need help creating a formula that will calculate the price per liter. The problem starts when I want to calculate the price per liter and the product is less than a liter (eg 0.3l). I understand everything mathematically, but I don't know how to create a formula that will calculate...

price per liter = price / (number of liters) X = 30 / (0.3) X = 100 Yes, that's enough for you, do you still want an Excel paste?

I will be grateful for the formula.

Excel Formula: Calculate Price Per Liter for Any Product Capacity (Above or Below 1L)

Reply | New topic

#1 16300625 23 Feb 2017 09:49

godzio1995 godzio1995

Level 9

» |

Post #1
16300625 23 Feb 2017 09:49

Hello,

I need help creating a formula that will calculate the price per liter.
The problem starts when I want to calculate the price per liter and the product is less than a liter (eg 0.3l). I understand everything mathematically, but I don't know how to create a formula that will calculate the price per liter, no matter if the product has a capacity above or below a liter?
ADVERTISEMENT
#2 16300731 23 Feb 2017 10:48

sanfran sanfran

Network and Internet specialist

» | Positive voted Helpful post? (+11)

Post #2
16300731 23 Feb 2017 10:48

price per liter = price / (number of liters)
X = 30 / (0.3)
X = 100

Yes, that's enough for you, do you still want an Excel paste?
ADVERTISEMENT
#3 16300993 23 Feb 2017 12:51

godzio1995 godzio1995

Level 9

» | Topic author Helpful post? (+3)

Post #3
16300993 23 Feb 2017 12:51

I will be grateful for the formula.
Helpful post

#4 16301010 23 Feb 2017 12:59

sanfran sanfran

Network and Internet specialist

» | Positive voted Helpful post? (+12)

Helpful post
Post #4
16301010 23 Feb 2017 12:59

Please.
Create an account, log in and become active in a forum and ads will not appear. You will receive points by participating in discussions.
Join this discussion.

Install the application

Didn't find an answer? Ask Artificial Intelligence

*I agree to send the question to OpenAI, Anthropic PBC, Perplexity AI, Inc., Kagi Inc., Google LLC - owners of language models in order to prepare the best response. The companies may monitor and log information entered into the form.

*I agree to publicly display my question and answer. The question and answer will be publicly available to everyone. The process may take a few minutes. Upon completion, you will be redirected to the page with the answer.

Wait...(2min)

Reply | New topic

Report a violation of the law

Excel Formula: Calculate Price Per Liter for Any Product Capacity (Above or Below 1L)

Didn't find an answer? Ask Artificial Intelligence