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

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

2 Answers

All function that can be used in excel


Use this link to download all excel Dicttionary function
http://www.xlfdic.com/


Thanks for choosing Fixya.........
Sandeep

Mar 18, 2011 | Excel Function Dictionary

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 Business & Productivity Software

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 Business & Productivity Software

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

Student marksheet prepare wtih Ms Excel With following conditions


Check all the Marks with IF Function if Mark is less than 35 give the total mark else give the rank
for Ex:;
if(Or(m1<35,m2<3,m3<35,.....),TotalMark,Grade)) [enter]
here m1,m2,m3 ...are the cells denoting Marks, Totalmark is the cell Showing total marks and Grade is the grade applied for the condition. here also you can use one more if function to find the grade among A,B,C,D,E
First this function check whether any of the given marks are less than 35. if any of the marks is less than 35 it will get the answer TRUE for the OR Function and you will get the Totalmark Cell VAlue, else it will go to Grade Clause.

Dec 06, 2008 | Business & Productivity Software

1 Answer

Ms excel function


I'm not entirely sure how you want to use this, but it is fairly easy to automatically assign a value to a cell based on the value in another.

Let's assume that you enter your score (A, B, C or D) in cell A1. If you put the following equation in cell A2 it will then display the corresponding score:

=IF(A1="A",3,IF(A1="B",2,IF(A1="C",1,IF(A1="D",0))))

You can go on adding as many further 'IF' statements as you like.

You can elaborate on this a bit by changing it to the following:

=IF(A1="A",3,IF(A1="B",2,IF(A1="C",1,IF(A1="D",0,"Not Scored"))))

By adding the final 'Not Scored' entry it prevents cell A2 from displaying 'FALSE' as an output.

Matt

Feb 26, 2008 | 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

2 Answers

EXCEL ALL SHORT FORMULA


hiiiiiii
u know vlookup function,then piviot table
u know na tell short formula
genious...

Dec 14, 2007 | Microsoft Excel for PC

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

95 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18299 Answers

Tony

Level 3 Expert

2598 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...