Question about Microsoft Office Standard for PC

2 Answers

Formula for percentages

I am trying to set up spread sheet for table tennis league, column b is games played, column c is games won and column d percentages

Posted by on

  • Anonymous Aug 02, 2008

    25000 x 12.5% + =

  • rajugulekar0 Aug 02, 2008

    480000X30%- =

×

Ad

2 Answers

What is 20% of 6185.16?

Posted on Mar 05, 2008

Ad
  • 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
  • 883 Answers

Column d = column c divided by column b. result can be formatted to 3 decimal places or anything you prefer.

Posted on Sep 10, 2007

Ad

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

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

I’m trying to create a vlookup formula cell F2 that will look up the merchandise code in E2 and display the name using column K and L. Look for wpexact match


create an additional sheet in worksheet at the bottom of worksheet is a +
add a sheet put each merchandise code in each row going down the column worksheet.
in the next row put the name beside the matching code.
then when finished sort on both columns using the merc, code to sort ascending.

code_lookup1-lcxufp0edjxqrfkkn22ib0r3-5-0.jpg notice in the next picture the addition of $ in the row
this is done to allow you to copy down the formula and leave the reference array the same

code_lookup2-lcxufp0edjxqrfkkn22ib0r3-5-2.jpg look at bottom of spread sheet to see additional sheet being used called code to create the array for the look up. With more array rows just modify the formula to say =lookup(a2,codes!$a$1:$b$200)
lookup will give you a text answer where as vloopup will give a numerical value !


code_lookup3-lcxufp0edjxqrfkkn22ib0r3-5-5.jpg

May 07, 2018 | The Computers & Internet

1 Answer

How do I check that I have copied the formula to a new cell?


Click on the column-heading to select the entire column.
Right-mouse-click to select "copy".
Move the mouse-pointer to where you want the copy to appear.
Right-mouse-click and choose "insert copied cells".

Sep 16, 2014 | Microsoft 1994 Office Excel Spreadsheet...

2 Answers

What country won the most Olympic medals in table tennis?


Thecountry with the most medals in the Olympic Games is China with 41 medals (notincluding the 2012 Olympic Games).

Aug 05, 2012 | Sport & Outdoor - Others

1 Answer

I'm in my 50's, can I start playing table tennis?


Definitely! You should know that Table tennis is asport for all ages, and it is never too late to get started. You should know that in the year 2008, Olympic table tennis canbe called the Veteran Year as 38 year old Gao Jun and34 year old **** Chendirectly qualified for the 2008 Beijing Olympic Games on the women's side. Andon the men's side, 45 year old David Zhuangwon the right to attend the Olympic Games as the USA' sole male representative.

Jul 09, 2012 | Sport & Outdoor - Others

2 Answers

Sorting a single column with both first name and last name


are you using mssql then it must be something like this

Select firstname + ' ' + 'lastname' as 'name' from tablename order by lastname

Sep 26, 2009 | Computers & Internet

1 Answer

How to add % (Percentage column ) in the excel


The formula is 200/700 equals the percentage;if you're in columns a, b, and c, the formula in c1 will look like:
=b1/a1.

Then you can format the cell to show the number (.2857) as a percentage (28.57%).

Jan 03, 2009 | Microsoft Computers & Internet

1 Answer

Excel formula


I'm assuming you'd like to assign a numerical value to cardinal references (1st, 2nd, 3rd, 4th, etc.).

Best way to do this is to create a quick lookup table on a separate sheet of the same .xls document. Down at the bottom of the page, click on Sheet2 and create a quick table where column A has 1st, 2nd, 3rd, etc. and column B has your values.

Now click back to Sheet1 where your data is and in A2 put this formula:
=VLookup(A1, Sheet2!$A$1:$B$x, 2, FALSE)
Note: replace the lower case x in the formula above with the number of the last row of data in your lookup table on Sheet2.

You can copy and paste this formula down the column to calculate your other values.

Hope that helps!
Terry

Aug 30, 2008 | Microsoft Excel for PC

1 Answer

Copying data from one sheet to another if two fileds match


Nope, sorry, although I am truly an expert at Excel formulas, I do not understand what you are trying to end up with in the final cell. We can compare a specified field with two spreadsheets - use named ranges and index/match lookup formulas. But then where you really lose me is in reading "a generic field" to find a match, and then placing what "data from another field" into what "other sheet" - ? See the confusion?

Best way to compare 2 given parameters would be to use a nested if formula, with index/match combo. Here is a simple Excel example of how such a formula could be structured:

Sample Data (columnar arangement):
A1: Part B1: Code C1: Price D1: Find Part E1: Find Code
A2: x B2: 11 C2: 5.00 D2: y E2: 12
A3: x B3: 12 C3: 6.00 D3: y E3: 11
A4: y B4: 11 C4: 7.00 D4: x E4: 12
A5: y B5: 12 C5: 8.00 D5: x E5: 11

To retrieve the price for part y with code 12 and return the value to cell F2, type the following formula in cell F2:
=INDEX($C$2:$C$5,MATCH(D2,IF($B$2:$B$5=E2,$A$2:$A$5),0))

Press CTRL+SHIFT+ENTER to enter the formula as an array formula. The formula returns the value 8.00.

To take this one step further, with range names, this example will find one value at a specified location which matches a specific row header value and column header value. Let's say the range is home values (Range=HomeVal), Column A of HomeVal contains street addresses,"row headers" (Range=StAddress), and Row 1 contains dates of the various values that are in the body of the table, "column headers" (Range=Dates). To return the specific value from the range HomeVal to another sheet, where A1=address specified and A2=date specified:
=INDEX(HomeVal,(MATCH($A$1,StAddress,0)),(MATCH($A$2,Dates,0)))

Then make sure to press CTRL+SHIFT+ENTER to enter the formula as an array formula - if you only hit enter, these types of formulas will not work properly.

Please post back if you need further help, with more details, otherwise thank you for using and rating FixYa!

Jul 08, 2008 | Microsoft Computers & Internet

1 Answer

Lookup,s


If you can move your name column (C) to the first column, you could leverage the VLOOKUP formula pretty easily.
To do this, do the following:
1) Move the C Column to be the A Column, shifting all other columns to the right.
2) (optional) Insert a new row at the top of the sheet (to hold the formula & seach value)
3) Use A1 as your search field.
4) In A2, enter the following formula:
=VLOOKUP($A$1,$A$2:$C$6,3,)

Describing above parameters, in the formula:
$A$1 -> the search field (name your looking for).
$A$2:$C$6 -> The table/grid you wish to search and return values from. The left most column (A) must contain the values to be searched.
3 -> is the column number (A=1,B=2,C=3, etc) within the table/grid to return.

If you cannot make the name column your first (A) column, there are more complex ways to do this. For instance, create a new sheet which redisplays the info in the structure easier for this method, and perform the VLOOKUP on that data. Other options might exist in creating a complex formula that would get you what you want.
Also, if you can sort column A (names) it would find results faster, if your data set is large.

Feb 03, 2008 | Microsoft Excel for PC

5 Answers

Formula required


at first select the 1st page data and select data-subtotal from the upper menu list.
then enter the formula as =sum(1stpageSubTotal,2ndpageSubTotal,3rdpageSubTotal) then Press Enter.

If not solved pls get me that data as to reference.

thanks

Dec 04, 2007 | Microsoft Excel for PC

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

98 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

3015 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18429 Answers

Alun Cox

Level 3 Expert

2678 Answers

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

Answer questions

Manuals & User Guides

Loading...