Question about Microsoft Excel for PC

2 Answers

Help I dont know mutch of excel

Wat Function do I use to
let say I want to put in a surten % of mark- up

Posted by on

2 Answers

  • Level 1:

    An expert who has achieved level 1.

    Corporal:

    An expert that hasĀ over 10 points.

    Mayor:

    An expert whose answer gotĀ voted for 2 times.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 18 Answers

To calculate 30% of any number you want to multiply that number by 0.3

To do this in Excel, choose the cell you want the calculation to appear in and type "=X1*.3" where X1 is the cell with the list price in it. If all your list prices are in Column C, for example... and you want calculated trade prices in Column F... you could put "=C1*.3" in the first row of Column F and "=C2*.3" in the second row of Column F and so on...

If you have a long list, just enter the formula in the first row of Column F (or your selected column) hit ENTER, then position your cursor at the lower right corner of the F1 cell and you will see your arrow change to a crosshair. Now click and drag down the column to copy the formula down as far as you like.

Good luck!

Posted on Sep 11, 2008

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

If I am doing price analysis and have List Prices but want to formulate the whole sheet that it will calculate 30% of prices to give me trade prices

How can I do this

Posted on Sep 03, 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

What is the "&" symbol for in excel 2010?


The "&" symbol is commonly known as "ampersand" and it is a calculation operator. Ampersand can be used in Excel 2010 to join text items from different cells. It functions much similar as "CONCATENATE" function. The output value you will get by using ampersand function will be the same as the one you will get by using CONCATENATE function. For example, =A1 & B1 returns the same value as=CONCATENATE(A1, B1)

To know more about the CONCATENATE/ ampersand function, you can refer to the following webpages:
http://office.microsoft.com/en-in/excel-help/concatenate-function-HP010342288.aspx

(Important: Below mentioned link is of a third-party website. We recommend you to update your security software thoroughly before clicking on the link.)
http://excelsemipro.com/2010/08/concatenate-function-or-ampersand-operator-in-excel/

(Important: Below mentioned link applies to Excel 2007. Still, you can refer it to understand more about ampersand function.)
http://office.microsoft.com/en-in/excel-help/combine-the-contents-of-multiple-cells-HA010248390.aspx?CTT=1

GuruAid.com

Jul 30, 2014 | Microsoft Excel 2010

1 Answer

How do i adjust the wat data is entered into excel?


We recommend you contact Motorola Solutions for help.


portal motorolasolutions com

Mark
Motorola Support

Jun 12, 2014 | Zebra LI4278 Barcode Scanner

1 Answer

Where do i put the antifreeze in my 2006 hhr?


My wife that dont no mutch said tack the cap off where u put water and put some in there

Jul 01, 2011 | 2006 Chevrolet HHR

3 Answers

Cltuch 97 excel


dont listen to them, easiest way is: remove air intake box(3 nuts)
remove nuts surrounding the outer gearbox(about 6) and then remove the gearbox mounts
lower the gearbox and move slightly to the drivers-side. best to put a block or jack under it. then take the fly-wheel off(marking where it sits against the clutch kit)
and then pull the clutch plate off, making sure all fingers are not bent. i picked up a full clutch kit 2nd hand for 25$

Nov 14, 2009 | 1990 Hyundai Excel

1 Answer

RANK FOR PASSING STUDENTS


You will have to use a logic saying If subject1 > 34 and subject2 >34 and subject3 > 34. Idead is to tell the prog that all subjects have to be > 34 by using the AND function. If you use OR function, then the first subject having > 34 will complete the condition and you will get the result, which will be wrong. So, use the AND function. How? Use the help on Using functions in Excel or whatever you are using. They all have it inbuilt.

Aug 22, 2009 | Computers & Internet

1 Answer

I want the all excel formulas


You will never find a fully comprehensive list anywhere because there are literally hundreds in the basic Excel application and thousands that can be added in as you go via macros. More are being added every time a new version of Office comes out.

But, the easiest way however to get a basic list of functions if your not printing is to hit the function button and simply scroll down the list. The syntax (an example of the method by which you should be formatting the formula) and a definition will list in the bottom of the dialog as you select each function.

That said, you are better solving individual problems as you learn Excel then trying to memorize all the functions themselves. Many, such as mathematical operations are common sense anyway.

Jun 19, 2009 | Microsoft Computers & Internet

4 Answers

Dont understand how to use vlookup in excel 2007


This tutorial also helped me much to understand how vlookup works:

http://www.myhowtoos.com/en/excel-howtoos/84-how-to-match-values-in-excel-using-vlookup

Feb 18, 2009 | Microsoft Computers & Internet

1 Answer

Please suggest me how i use the v lookup and h look up


Select a blank cell in workbook. Click the function icon located informula bar("fx"). In the popup Insertwindow Select category as ALL.Select the function you want to get help and click on "help on this function " located in the left down page. You can get all the formula help bu using this method.  

Feb 03, 2009 | Microsoft Excel for PC

1 Answer

Excel Formula


Yes you can and there are two choices. The simple solution is to label a cell "divide by" and put your number in that filed. Then, by changing only that, your answer (in a separate cell) will be available.
There are more complex solutions -assuming your divide by number had some rhyme and reason that could be put in place but.....try this first and at a later date go back and play. Learning to do that will give you more than a fair amount of Excel expertise....something you may find fairly valuable as you continue on using Excel. FYI...I have developed full blown applications on Excel....it is an excellent tool. Hope this helps....Tango.

Feb 05, 2008 | Microsoft Excel for PC

Not finding what you are looking for?
Microsoft Excel for PC Logo

99 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18385 Answers

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

Answer questions

Manuals & User Guides

Loading...