Question about Computers & Internet

1 Answer

I am working on a spreadsheet for my boss that will allow him to track the progress of our sales team. I've done the formatting, etc, but am now onto the formulas. I have suggested revisions to the sheet to allow formulas to work, but he already signed off on phase one (approving said formatting), so I kind of built myself inside my house without building a door, so to speak. Now, my task is to highlight the areas the sales team is doing well or needs improvement. In order to do that, we need the sales team to check off specific cells. I am figuring using an "X" and having the formula use that as reference is feasible. But, here's what I can't figure out. I am not sure which formula or formulas I should use. I need to be able to return one of four possible values. If every cell contains an "X", then it should return "A", if 100% of only a portion of all those cells have an "X", then it should return "B", if only 80% of the previous portion are marked, then "C", and less than 80%, N/A. I was thinking using multiple If statements but dont know how to do with the percentages.

Posted by on

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Master
  • 916 Answers

Try having the cells refer to the ones you would like in the formula then have a statement something like if a = 1 then yes or if a = 2 then no and have it after become a percentage by dividing the sum by the count. Let me know if you need more help.

Posted on Dec 18, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

I've purchused a 8gb sony sd memory card and when


It may not be formatted in a compatible format supported by your BOSS Audio system. Check the owner's manual of the unit,it should indicate which format it will support. Copy the data currently on the memory card back to a file on your PC/Laptop and reformat the card to match your BOSS unit. Have you tried other memory cards? It is also possible that the card has too large a capacity for the BOSS unit. T

Feb 13, 2012 | 2002 Nissan Altima

2 Answers

How do i download music to my mp3


MP3 players can only play music files in mp3 file format. You can download mp3 music files onto your computer and then copy them to your MP3 player.
For CD disks you need to convert your CDs to mp3 music files onto yourcomputer or download them from the Internet and then copy them to your MP3player.
You can do this using Windows Media player and Rip the CDs - Media Player willcreate a MP3 music file for each music track.
Click on this link for instruction on converting music files to mp3 file format:- http://www.fixya.com/support/r5798418-creating_transferring_mp3_music_files

Jul 02, 2011 | Sylvania Audio Players & Recorders

1 Answer

Hi. By the grace of Almighty it is hoped that you and your family members would be in good health. I need a link to download a multiple sheets Excel Workbook to manage our daily sale, inventory and...


Here are your links Sales
http://www.brothersoft.com/sales-management-report-spreadsheets-for-excel-366701.html
Inventory
http://www.brothersoft.com/downloads/inventory-spreadsheet.html
Purchase
http://www.spreadsheet123.com/ExcelTemplates/purchase-order-template.html

Jun 26, 2010 | Microsoft Office Excel 2003 for PC

1 Answer

I ve copied the songs in to my player. but still its displaying 'no songs found'.... wat to do?


check that you have teh right format of file , this can be done by going onto your devices website and looking up what format your device can take ie :wma , mp3 etc , they are simple to change if it is wrong just go onto the internet and find a mp3 converter or wma converter and convert your music then put this on your device

Jan 12, 2010 | Philips GoGear HDD075/17 MP3 Player

1 Answer

Msworks spreadsheet ver 8 shuts down


Try to update your works from works 8.5 from the link below ... before you install the uodate make sure you have the disc for works ..

http://www.microsoft.com/products/works/downloads.mspx#Works8Update

May 02, 2009 | Microsoft Works 8.0 for PC

1 Answer

My wife's Eureka 5855 Boss Bagless Wide Track stopped running


its probably something in the motor. you may have to replace the motor which could cost around $50.

Apr 15, 2009 | Eureka 5849A Boss Bagless Upright Cyclonic...

1 Answer

Microsoft excel(data analysing)


Microsoft Excel is an application used for building spreadsheets. It has many built in calculation and graphics tools. Some people use it to track expenses while other use it to graph numbers for charting process. As far as data analyzing it all depends on the data. Whether is sales figures or budget information. It all can be done inside of excel using it built in formulas and functions.

Sep 22, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

81 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

kakima

Level 3 Expert

102366 Answers

David Payne
David Payne

Level 3 Expert

14161 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...