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

Why would a primary register show no display and the secondary register will allow for sales but will not allow for storing tickets?


Is this a POC (Point of Sale) setup in a restaurant or store?
If so, the primary will have the data base on it, so it needs to be operational for the Secondary to work properly. Start with why the primary is not working - Check the easy stuff first: Is the Monitor Turned on? Is the PC powered on, has it been rebooted etc. AFTER you get the primary working again you should reboot the secondary and ensure they are connecting to each other (usually over a network hub or a network cable).

Dec 10, 2014 | Computers & Internet

Tip

How to set, modify, remove and recover Excel 2007 password?


Microsoft Office software developers have been paying more and more attention to the means of protecting users' information, and Microsoft Excel has not been overlooked. Recent versions of the program provide users with advanced features for protecting Microsoft Excel documents against unauthorized access of the information stored in them. The methods include completely blocking access to a document, forbidding saving changes to it. Besides, some expert team even designed Excel password recovery tool to recover Excel 2007 password for those who have lost Excel password.
Set a password to open or modify Excel 2007 password Set a password to open Excel 2007
  1. Click the Microsoft Office Button office.gif , point to Prepare, and then click Encrypt Document. excel-document.gif
  2. In the Password box, type a password, and then click OK. You can type up to 255 characters. By default, this feature uses AES 128-bit advanced encryption. Encryption is a standard method used to help make your file more secure.
  3. In the Reenter password box, type the password again, and then click OK.
  4. To save the password, save the file.
Set a password to modify a Excel 2007 Spreadsheet In addition to setting a password to open an Excel spreadsheet, you can set a password to allow others to modify the spreadsheet.
  1. Click the Microsoft Office Button office.gif , click Save As, and on the bottom of the Save As dialog, click Tools.
  2. On the Tools menu, click General Options. The General Options dialog opens.
  3. Under File sharing, in the Password to modify box, type a password.
  4. In the Confirm Password dialog, re-type the password. Click OK.
  5. Click Save.
Remove password protection from an Excel spreadsheet
  1. Use the password to open the spreadsheet. (Note: If you don't know the open password, you have to recover Excel password with the third Excel password recovery tool)
  2. Click the Microsoft Office Button office.gif , point to Prepare, and then click Encrypt Document.

    excel-document.gif

  3. In the Encrypt Document dialog box, in the Password box, delete the encrypted password, and then click OK.
  4. Save the spreadsheet.
Recover Excel 2007 password with Excel Password Unlocker Excel Password Unlocker is a popular Excel password recovery tool that can recover Excel password from Excel 97 to Excel 2007
Related Office 2007 document password tips:
How to set, modify, remove and recover Word 2007 password?
How to set, modify, remove and recover PowerPoint 2007 password?

on May 21, 2010 | Computers & Internet

Tip

How to import DVD Movies onto Windows Movie Maker for edit


Need to convert DVD to Windows Movie Maker so you can edit DVD on Windows Movie Maker at the best quality? How exactly can you edit DVD video on Windows Movie Maker? Are you upsetting with importing DVD to windows movie maker? This guide is going to show you how to edit DVD movies on Windows Movie Maker with DVD to Windows Movie Maker Converter.
Windows Movie Maker is basic video creating/editing software introduced by Microsoft. It contains features like effects, transitions, titles/credits, audio track, timeline narration, and Auto Movie. However, it can only accept video files in format AVI, WMV, MPEG, etc. So, if you want to import your DVD to Windows Movie Maker, it is better for you to convert the DVD to WMV or AVI format enable in Windows Movie Maker first.
You can download Daniusoft Best DVD ripping software, install and run it. It is the DVD to Windows Movie Maker Converter which can help you rip DVD to AVI WMV and then you can import DVD to Windows movie maker. Then we can finish the conversion in 4 simple steps:
efecfe2.jpg
Step 1: Import DVD files to DVD to Windows Movie Maker Converter.
You can either click Add button to insert the files you want to convert, or easily drag & drop the DVD files into 'Getting started' table. You are allowed to load DVD Rom, DVD folders, ISO files or IFO files respectively.
Step 2: Customize output settings for Windows Movie Maker editing.
Click the "Convert to" drop-down menu to select AVI or WMV as output audio format; Also, you are allowed to customize the output parameters by clicking "Settings" button .Then click the "Target Path" button to find the destination folder for saving output AVI or WMV format, or the files will be saved as default. A regular DVD movie has multiple subtitles and audio tracks, and you can select the right one for you.
Step 3: Start conversion.
Click "Start" button on right bottom of the main interface, you are allowed to start convert DVD to windows movie maker WMV AVI. All the tasks of conversion will be finished at fast speed and high output quality.
Then go ahead with this DVD to Windows Movie Maker Converter to rip DVD to Windows Movie Maker so as to edit DVD video on Windows Movie Maker (*mswmm) and make your personal movies.

on Mar 16, 2010 | Computers & Internet

2 Answers

I get #error not_ auth when I search on bing


ask to the company browser, mozilla, i.e, safari, and maybe you need to update the add-on +pluggins,etc.
God bless you

Jul 19, 2013 | Computers & Internet

1 Answer

Connecting external device to PC/Laptop & no sound


why not use a Y spliter go to radio shack and see if that would help you out ask them is for audio they might help you

Aug 04, 2009 | Computers & Internet

Tip

How to convert excel to PDF


According to a recent report,Adobe estimates that there are about 300
million PDF in circulation,the amount and use of PDF format is still growing exponentially.People nowadays cannot live without PDF files.
Sometimes,you need to convert excel to pdf files,but how to convert excel spreadsheets to pdf with retains all the features of the original excel file?

you will need pdf converter to convert excel to pdf.

1.Run the pdf converter program.

2.Add PDF files,specify output folder.

3.Start conversion.

Note: you cn add PDF properties to the output PDF file, like author, passwords, allowed actions, etc.

on Mar 08, 2010 | Computers & Internet

2 Answers

Have a excel password protected file. have forget my password. help me in opening my file


How to Crack Excel Spreadsheet Passwords by Petri IT Knowledgebase Team - January 8, 2009 Often when an employee departs, they take important Excel passwords with them. This guide outlines how to use a simple Excel password recovery application to crack lost or forgotten passwords, allowing you to unlock password-encrypted Microsoft Excel documents quickly as possible.
Step 1: Download and Install the Office Password Recovery Utility To perform the following recovery steps, you'll need to grab the download of Office Password Recovery Pro, available directly here. (2.1Mb)
Once you've downloaded the program, run the install with the default options.
Step 2: Navigate to the Protected File and Begin the Recovery Process Click the Open button on the top left, navigate to the protected spreadsheet file:

May 09, 2009 | Computers & Internet

1 Answer

I have a new PC using Works 8.5 I have a problem with loss of formatting when I do a dabase report output, and paste it to a works spreadsheet ( or to an Excel 2007 spreadsheet) All larger fonts and bold...


You may be able to set the cell styles for every workbook/worksheet. Take and re-format your exported spreadsheet the way you would like it to look, then highlight those cells and poke through the menus until you find the cell formatting options (I don't use Works that much, so I'm not sure of the actual menu path) and see if there is an option for formatting those cells in that manner as a general default cell format.

Feb 09, 2009 | Computers & Internet

2 Answers

I need assistance using microsoft works. To be specific, the spreadsheet. I thought that it was similar to the Excell program, but, I failed to learn how to make and print lines on my charts. I was...


Please use the open source OpenOffice which is compatible with Microsoft Office. You will find the spreadsheet very easy to use and quite similar to Excel

http://www.openoffice.org

you may also like the opensource and free software available from my website:

http://rexmo.net



Nov 12, 2008 | Computers & Internet

1 Answer

I get the following message when i try open an excel spreadsheet. i cannot see and info on the sheet. Compatibility Report for Info2008.xls Run on 10/17/2008 18:01 The following features in...


Either you need to upgrade your version of Excel or the person creating the spreadsheet needs to save it in a format for compatability. For example, the person who created the workbook simply needs to do File and Save As. Under type, one can choose a format for older versions of Excel.

Hope this helps!

Oct 18, 2008 | Computers & Internet

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

joecoolvette
joecoolvette

Level 3 Expert

5660 Answers

kakima

Level 3 Expert

98694 Answers

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

Answer questions

Manuals & User Guides

Loading...