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

• 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

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

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this 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.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

Related Questions:

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

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

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...

Inventory
Purchase

Jun 26, 2010 | Microsoft Office Excel 2003 for PC

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

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 ..

May 02, 2009 | Microsoft Works 8.0 for PC

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...

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

Open Questions:

Related Topics:

82 people viewed this question

Level 3 Expert

Level 3 Expert