Craft Show Display Ideas
http://www.hipgirlclips.com/store/images/hair-bow-gift-basket-tutorial-title.jpg
http://www.hipgirlclips.com/store/images/clothesline-for-craft-show-display-title.jpg http://www.hipgirlclips.com/store/images/bow-card-punch-tutorial-title.jpg
http://www.hipgirlclips.com/store/images/hair-bow-display-bow-title.jpg
http://www.hipgirlclips.com/store/images/hair-bow-holder-craft-show-display-title.jpg http://www.hipgirlclips.com/store/images/custom%20bow%20cards-3-sm.jpg
http://www.hipgirlclips.com/store/images/dress-form-craft-show-display-title.JPG

Go Back   Hip Girl Boutique Free Hair Bow Instructions--Learn how to make hairbows and hair clips, FREE! > Ribbon and Bows > How to make...

How to make... Hairbows, hair clips, bottlecaps, ribbon shirts, flip flop...

Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old 01-18-2011, 08:50
meganskiddos's Avatar
Senior Member
 
Join Date: Mar 2010
Location: Texas
Posts: 4,246
Default 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; 01-18-2011 at 10:29.
Reply With Quote
Sponsored Links

  #2 (permalink)  
Old 01-18-2011, 08:54
GARandMCR's Avatar
Senior Member
 
Join Date: Jan 2011
Location: Houston, Texas
Posts: 3,611
Default Re: Spreadsheet formula help real quick perty please!!!!!

All you have to do is enter the formula once adding the total, the buy fee and the pp fees (ie: =B25+B26+B27). Then you can fill that formula down the column instead of having to reenter it a bunch.

HTH.
__________________
There is a grave difference between supporting the war effort and those in uniform. If you do not stand behind our troops, feel free to stand in front of them.

Also, it has been 147+ days since I have seen my DH, so don't expect me to be all rainbows and sunshine when you are being stupid. Oh, let us not forget the glitter.
Reply With Quote
  #3 (permalink)  
Old 01-18-2011, 08:56
meganskiddos's Avatar
Senior Member
 
Join Date: Mar 2010
Location: Texas
Posts: 4,246
Default Re: Spreadsheet formula help real quick perty please!!!!!

Quote:
Originally Posted by MaredithRoberts View Post
All you have to do is enter the formula once adding the total, the buy fee and the pp fees (ie: =B25+B26+B27). Then you can fill that formula down the column instead of having to reenter it a bunch.

HTH.
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)
Reply With Quote
  #4 (permalink)  
Old 01-18-2011, 08:56
CKane's Avatar
Senior Member
 
Join Date: Aug 2010
Location: White House, TN
Posts: 2,584
Default Re: Spreadsheet formula help real quick perty please!!!!!

Quote:
Originally Posted by meganskiddos View Post
Ok, I have my forms and ss set up for the next GB. I have the =sum(rows) set up to where it totals where I am at on slider and pearl totals. Got it, I understand that part. However, I am wanting a final column on the very end to total their orders with the buy fee and PP fee. What is the formula? Is there a way to do it once and when each person enters an order, it does it automatically or would I have to manually enter the formula after each order?

Can someone please help me out with this? Sure would save me some headache!

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!
Reply With Quote
  #5 (permalink)  
Old 01-18-2011, 08:57
meganskiddos's Avatar
Senior Member
 
Join Date: Mar 2010
Location: Texas
Posts: 4,246
Default 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)
Reply With Quote
  #6 (permalink)  
Old 01-18-2011, 08:59
karina721's Avatar
Senior Member
 
Join Date: Sep 2008
Location: Northwest Indiana
Posts: 2,652
Default Re: Spreadsheet formula help real quick perty please!!!!!

Type '3 and then at the bottom of the cell, bottom right side, place your + mouse and drag it down.
__________________
Mom to 2 girls, 7 & 4
Reply With Quote
  #7 (permalink)  
Old 01-18-2011, 08:59
meganskiddos's Avatar
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
  #8 (permalink)  
Old 01-18-2011, 08:59
CKane's Avatar
Senior Member
 
Join Date: Aug 2010
Location: White House, TN
Posts: 2,584
Default Re: Spreadsheet formula help real quick perty please!!!!!

Quote:
Originally Posted by meganskiddos View Post
How do I fill it down the form is what I'm having trouble with?
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!
Reply With Quote
  #9 (permalink)  
Old 01-18-2011, 09:00
meganskiddos's Avatar
Senior Member
 
Join Date: Mar 2010
Location: Texas
Posts: 4,246
Default Re: Spreadsheet formula help real quick perty please!!!!!

Quote:
Originally Posted by karina721 View Post
Type '3 and then at the bottom of the cell, bottom right side, place your + mouse and drag it down.
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)
Reply With Quote
  #10 (permalink)  
Old 01-18-2011, 09:04
CKane's Avatar
Senior Member
 
Join Date: Aug 2010
Location: White House, TN
Posts: 2,584
Default Re: Spreadsheet formula help real quick perty please!!!!!

Quote:
Originally Posted by meganskiddos View Post
AAAHHH...That is what I was looking for So simple. Thank you!!!
you are VERY welcome - remember though... that if you have a formula that involved only one particular cell, but need the forumla in several cells - then that will mess up unless you do this:

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!
Reply With Quote
Sponsored Links
300-700-forum-banners
wholesale rompers, dresses, bloomers, hat, headbands, leg warmers, flower layers, tulle, boutique clothing and other craft supplies
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


New products--peelnstick double-sided-tape for lining clips
http://www.thehairbowcompany.com/assets/images/affiliateBanners/affiliateBanner3.jpg
hip girl boutique 1" metallic gold gliter sparkle ribbon
hip girl boutique grosgrain ribbon wrapped headbands for girls women baby toddler
hip girl boutique goody ponytail pigtail holder for women girl toddler baby

All times are GMT -5. The time now is 01:44.


Powered by vBulletin® Version 3.8.3
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
LinkBacks Enabled by vBSEO 3.1.0
Hip Girl Boutique Instructions - Copyright © 2007

Ad Management by RedTyger