Thanks If the tonnage is greater than 5 ton for 20 yard & greater than 7for 30 yard charge overage of $ 45 per ton. if([20 Yard Dumpster],>5,if([30 Yard Dumpster],>7= 45?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
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,074 Points 20k badge 2x thumb
I have no idea what your question is. Try putting the question in the body of the post (not the title) and provide greater detail.
Photo of Laura

Laura

  • 20 Points
Mary, I would write this formula like this. 


If(([20 Yard Dumpster]=true and [Tonnage]>5) or ([30 Yard Dumpster]=true and [Tonnage]>7),45,0)