Formula Trying to create a charge driven form size of container

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

Trying to create a formula so when a 20 yard dumpster is greater than 5 tons or a 30 yard dumpster is over 7 tons a charge of $45 per ton is applied to the total price charged. 

Photo of MARY

MARY

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,224 Points 20k badge 2x thumb
What are the field names and types that you are using for inputs and what is the output field type?
Photo of Matthew

Matthew

  • 20 Points
This would be a field called something like "Over Weight Charges" (Formula Numeric, currency)

If([Dumpster Length]=20 AND [Wgt in Tons]>5, 45*([Wgt in Tons]-5),

If([Dempster Length]=30 AND [Wgt in Tons]>7, 45*([Wgt in Tons]-7),

0))

You would then add your Subtotal + Over Weight Charges = Total Charges.