View Single Post
  #7 (permalink)  
Old 01-18-2011, 08:59
meganskiddos's Avatar
meganskiddos meganskiddos is offline
Senior Member
 
Join Date: Mar 2010
Location: Texas
Posts: 4,246
Default Re: Spreadsheet formula help real quick perty please!!!!!

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?


Quote:
Originally Posted by CKane View Post
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??
LOL

I can do screenshots if you'd like??
__________________
******************************************
STRIPED GLITTER ELASTIC!!!!!
ORDER:
https://docs.google.com/spreadsheet/...Nmd0E6MQ#gid=0

FACEBOOK GROUP FOR AWESOME BUYS:
http://www.facebook.com/groups/182211411884577/
www.PamperedPrincessPretties.com (Wholesale supplies)
Reply With Quote