I think I get the formula part. It's getting it to auto do it for each one. How do I get it to do it for each person? Click and drag?
Originally Posted by CKane
for example is A has their total in it (autosum from all of their lines) - then your formula would be =a(line number)*product price+buyfee amount - that would then be your subtotal including buy fee
your next cell should be =b(line number)*3.9%+0.30 - this is for pp fees
the last cell would be =c(line number)+b(line number
That gives you their subtotal, your pp fees, and your ending total - all together...
do you get what I explained??
I can do screenshots if you'd like??