Wat Function do I use to

let say I want to put in a surten % of mark- up

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

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

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

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

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

(

http://excelsemipro.com/2010/08/concatenate-function-or-ampersand-operator-in-excel/

(

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

We recommend you contact Motorola Solutions for help.

portal motorolasolutions com

Mark

Motorola Support

portal motorolasolutions com

Mark

Motorola Support

Jun 12, 2014 | Zebra LI4278 Barcode Scanner

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

1st warm up the engine or

Apr 29, 2010 | 2003 kawasaki KDX 220 R

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$

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

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

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.

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

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

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

Feb 18, 2009 | Microsoft Computers & Internet

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

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.

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

Jan 28, 2016 | Microsoft Excel for PC

97 people viewed this question

Usually answered in minutes!

×