TeenHelp
Support Forums Today's Posts

Get Advice Connect with TeenHelp Resources
HelpLINK Facebook     Twitter     Tumblr     Instagram    Hotlines    Safety Zone    Alternatives

You are not registered or have not logged in

Hello guest! (Not a guest? Log in above!)

As a guest on TeenHelp you are only able to use some of our site's features. By registering an account you will be able to enjoy unlimited access to our site, and will be able to:

  • Connect with thousands of teenagers worldwide by actively taking part in our Support Forums and Chat Room.
  • Find others with similar interests in our Social Groups.
  • Express yourself through our Blogs, Picture Albums and User Profiles.
  • And much much more!

Signing up is free, anonymous and will only take a few moments, so click here to register now!


Education and Careers Work of any kind can get stressful at times. Ask in this forum if you need help with coursework, applications, and more.

Closed Thread
 
Thread Tools Search this Thread
  (#1 (permalink)) Old
ZiggyOtaku Offline
Ziggy~
Average Joe
***
 
ZiggyOtaku's Avatar
 
Name: Brittany
Age: 29
Gender: Female
Location: Georgia

Posts: 103
Join Date: April 23rd 2009

Excel formula help - April 29th 2010, 01:37 AM

Someone recently made a tracker at work to help the people in the front lanes (cashiers) keep track of how many sales they make. It's not for commission purposes, but just to see who is performing and who seems to need help in improving.

What I wanted to do was make it fair for everybody. Not everyone works the same amount of days, so some may only work 3 days a week and so forth. As it is right now everyone is set that they're working 4 days a week.

I offered to take this home and work on fixing it for everyone (since the original person who made it got fired) and I'm technically the front end leader there.

Here's a link to the image:
http://sadpanda.us/images/125598-V2KD0S4.jpg


I thought all I'd have to do is take the average row and change each column to something like =D#/# of days they work

But that makes an error for the rank column then and I wanted to see if anybody could help me work this out.



  Send a message via AIM to ZiggyOtaku Send a message via MSN to ZiggyOtaku  
  (#2 (permalink)) Old
.Brittany. Offline
AKA Reckless Emotion

TeenHelp Addict
************
 
.Brittany.'s Avatar
 
Name: Brittany
Gender: Female
Location: 100 Acre Woods

Posts: 7,924
Blog Entries: 209
Join Date: January 12th 2009

Re: Excel formula help - April 29th 2010, 06:49 PM

Could you go into a bit more detail about what each row is about? that might help me be able to answer your question



“You are braver than you believe,
stronger than you seem,
and smarter than you think.”


HelpLINK Mentor | Live Help Mentor | Article Editor
Forum & Chat Moderator
   
  (#3 (permalink)) Old
ZiggyOtaku Offline
Ziggy~
Average Joe
***
 
ZiggyOtaku's Avatar
 
Name: Brittany
Age: 29
Gender: Female
Location: Georgia

Posts: 103
Join Date: April 23rd 2009

Re: Excel formula help - April 30th 2010, 05:20 AM

I ended up getting it myself!
Though... now they want more information with it



  Send a message via AIM to ZiggyOtaku Send a message via MSN to ZiggyOtaku  
Closed Thread

Bookmarks

Tags
excel, formula

Thread Tools Search this Thread
Search this Thread:

Advanced Search

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




All material copyright ©1998-2019, TeenHelp.
Terms | Legal | Privacy | Conduct | Complaints

Powered by vBulletin®.
Copyright ©2000-2019, Jelsoft Enterprises Ltd.
Search engine optimization by vBSEO.
Theme developed in association with vBStyles.