View original (French)

PRICE CALCULATION PER KG, LITRE

Griseba Posted messages 124 Registration date   Status Member Last intervention   -  
Raymond PENTIER Posted messages 58230 Registration date   Status Contributor Last intervention   -

Hello,

I'm on Excel and I'm working on creating a table to print price display labels, but I'm looking for a formula to calculate the price per weight, per liter, based on the selling price.

For example, selling price 1.75€ (merged cells C3 and C4), quantity 1.5 liters (Cell D2), price per liter (D7)

Thank you for your help.

5 answers

  1.
    Raymond PENTIER Posted messages 58230 Registration date   Status Contributor Last intervention   17 496
     

    .

    Hello.

    Another oddity:
    why bother merging cells when you can simply increase the height of rows 5 and 3?

    1
  2. jordane45 Posted messages 30427 Registration date   Status Moderator Last intervention   4 833
     

    Hello

    what you're looking for .. is the "division"

    .
    Best regards,
    Jordane

    0
  3. Griseba Posted messages 124 Registration date   Status Member Last intervention   2
     

    Hello jordane45

    I don't understand your question.

    0
    1. jordane45 Posted messages 30427 Registration date   Status Moderator Last intervention   4 833
       

      it's not a question ... it's an answer.

      1.75/1.5 = price per liter!

      0
      1. Griseba Posted messages 124 Registration date   Status Member Last intervention   2 > jordane45 Posted messages 30427 Registration date   Status Moderator Last intervention  
         

        Oh well, thank you, it was actually quite simple.

        But which cell should I indicate since my sales price is located in two merged cells? (C3 and C4)

        Thanks in advance.

        0
      2. jordane45 Posted messages 30427 Registration date   Status Moderator Last intervention   4 833 > Griseba Posted messages 124 Registration date   Status Member Last intervention  
         

        If you "click" on the cell to use in the formula, it will choose for you (cell C3)

        0
      3. Griseba Posted messages 124 Registration date   Status Member Last intervention   2 > jordane45 Posted messages 30427 Registration date   Status Moderator Last intervention  
         

        Thank you very much.

        Does it also work if I have a 950g jar or a drink in a 33cl container?

        0
      4. jordane45 Posted messages 30427 Registration date   Status Moderator Last intervention   4 833 > Griseba Posted messages 124 Registration date   Status Member Last intervention  
         

        Well, it depends on the units...

        If you have a container in grams... the division will give you the price per gram...

        To get it per kilogram... you will need to multiply it.

        The same goes for centiliters... you need to multiply to convert to liters.

        0
  4. Griseba Posted messages 124 Registration date   Status Member Last intervention   2
     

    Unless I indicate 0.33 for liters and 0.250 for grams!

    0
    1. jordane45 Posted messages 30427 Registration date   Status Moderator Last intervention   4 833
       

      Well, of course...

      If you change the unit to liters or kilograms, multiplication won't be necessary anymore since you'll already be in the right unit...

      1
  6. Griseba Posted messages 124 Registration date   Status Member Last intervention   2
     

    Thank you jordane45 for your help.

    0