
How to make... Hairbows, hair clips, bottlecaps, ribbon shirts, flip flop... 
 Thread Tools  Display Modes 
 
Spreadsheet formula help real quick perty please!!!!!
Got it Thank you ladies!
__________________ ****************************************** 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) Last edited by meganskiddos; 01182011 at 10:29. 
Sponsored Links  

 
Re: Spreadsheet formula help real quick perty please!!!!! How do I fill it down the form is what I'm having trouble with?
__________________ ****************************************** 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) 
 
Re: Spreadsheet formula help real quick perty please!!!!! Quote:
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??
__________________  AMBER  I am who I am, I say what I mean, I mean what I say, I'm a great friend, and a formiddable opponent. Make a friend of me  I'll be one for life! 
 
Re: Spreadsheet formula help real quick perty please!!!!!
Ok, so one column has buy fee $3, how do I get that $3 to show up in that entire column instead of entering it in hundreds of times?
__________________ ****************************************** 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) 
 
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:
__________________ ****************************************** 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) 
 
Re: Spreadsheet formula help real quick perty please!!!!! go to the right bottom corner of the cell  the cursor will turn to a thin black + sign... when it does, drag that cell down all the way down the colum that you want to paste the formulas to.... it will copy it down but it will be for each consecutive line.... is that what you mean?
__________________  AMBER  I am who I am, I say what I mean, I mean what I say, I'm a great friend, and a formiddable opponent. Make a friend of me  I'll be one for life! 
 
Re: Spreadsheet formula help real quick perty please!!!!! AAAHHH...That is what I was looking for So simple. Thank you!!!
__________________ ****************************************** 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) 
 
Re: Spreadsheet formula help real quick perty please!!!!! Quote:
say  you have a shipping total in A2  you are trying to figure out shipping percentage totals for folks well the first formula would be: A2 * B2, right? But if you copied that down, it then would turn to A3 * B3 and you don't want that you have A2 is the shipping total  so the formula you would need to enter is $A$2 * B2  then when it's copied down, A2 never changes, but the b cells will!!! do ya get what I mean? LOL... sorry  explaining it over this without showing it can confuse me!
__________________  AMBER  I am who I am, I say what I mean, I mean what I say, I'm a great friend, and a formiddable opponent. Make a friend of me  I'll be one for life! 
Sponsored Links 
Thread Tools  
Display Modes  
 