# Calculating a fee based on QTY delivered and total fee outstanding

✭✭

I am looking to calculate a fee amount based on total fee and qty delivered. For example, if I have two items on a PO, but only one delivers, the Fee to be Paid would only be half of the total. If all items deliver, the "Total Admin Fee" would copy over to "Admin Fee to be Paid".

In the snip below, for the highlighted row, the "Admin Fee to be Paid" should be \$75 (total admin fee/4=75. One item of 4 was delivered). If 2 of 3 had delivered, \$150, 3 of the 4 it would be \$225, etc.

• ✭✭✭✭✭✭

Hey @Stitched

=[Total Admin Fee]@row * [Quantity Delivered]@row / [Quantity Ordered]@row

Will this work for you?

Kelly@Robert Harrison

• ✭✭✭✭✭✭

Hey @Stitched

=[Total Admin Fee]@row * [Quantity Delivered]@row / [Quantity Ordered]@row

Will this work for you?

Kelly@Robert Harrison

• ✭✭

Worked beautifully! Thank you!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!