Forum Discussion

Julietacloquell's avatar
Julietacloquell
Copper Contributor
Apr 24, 2023

Excel Formules

Good morning, I would like to know if you could provide me with some formulas. The case is that I need a price to be calculated depending on the information that I put. For example: A delivery (t...
Formulas and Functions
NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Apr 24, 2023

Julietacloquell 

As Mr Vogelaar  informed you, a little more information does not hurt anyone :).

 

Here is an example of a formula that you can use in Excel to calculate the price based on the information you provided:

 

`=IF(AND(DeliveryType="B",DeliveryType="C"),20*(NumPeople-1),0)+IF(Zone=2,120+IF(NumPallets>2,(NumPallets-2)*ExtraCostPerPallet,0),0)`

 

In this formula, `DeliveryType` refers to the type of delivery (B or C), `NumPeople` refers to the number of people making the delivery, `Zone` refers to the zone of delivery (in this case, 2), `NumPallets` refers to the number of pallets being delivered, and `ExtraCostPerPallet` refers to the extra cost per pallet for more than 2 pallets.

 

You can adjust this formula to fit your specific needs by changing the cell references and values as needed.

 

Done with the help of AI, the formula is untested and questioning your text.

 

If that is not what you want...I would like to refer you again to Mr. Vogelaar’s  message.

In addition, here is a link: Welcome to your Excel discussion space!

 

 

I hope this helps!

Resources