How do I create a formula in excell  that multiplies a number by a pertectage?
962305
= [number] * [number]%
699216
1) In a Word table, you can insert a formula.  Try it with a column of numbers.  Move cursor to the last cell, click TABLE, then choose FORMULA.  Choose SUM(Above).  This will add all the cell values.  The formula will look like this: {=SUM(ABOVE)}\n\n2) Using same WORD table, copy the numbers to a different column and try inserting a new formula.  This time choose a formula from the formula list.  I recommend AVERAGE.  Then the formula looks like this {AVERAGE(BELOW)}.\n\nTo view the formulae described above, highlight the result cell, right click, choose toggle field codes.  Repeat to return it to result.\n\nFor auto-text:\n\n1) Click INSERT, choose, AutoText, then choose which you want to use.  I presume that page numbering is probably most commonly used.  Best to insert it in header or footer.\n\n2) Try a reference.  Click on INSERT, choose Cross-Reference.  In order to use this feature you need to have some styles in use that re numbered.  They will appear in the cross-reference box for you to choose from.\n\n\nHope these help,\n\nKind Regards,\nQwertyKPH @ Yahoo!
613986
=IF(E12=0,0,\nIF(AND(E12>0,E12<4),\n5.9,IF(E12>=4,12.9,\n"negative value")))\n\nAll on one line!\n\nEdit:  The >= (greater than or equal to) is required else the value of exactly 4 would return "negative value"
1055911
To put the formulae into Excel,  make a cell and call it 'X'.  Do not put 'X' into the cell.  This cell will be where you place the value for x.  Ie, if x=2, then put 2 in the cell for 'X'.\n\nFirstly, I am not sure what the '+ 2E' means, I have interpreted it to mean 'x10^2', ie, 100, 10 squared.  If this is wrong, you will have to change the formulae accordingly.\n\nWe will assume the cell for 'X' is A1.\nThe first formula, y=234x+2E+06, is written, into a new cell:\n'=((234* A1) * 100) + 6'\nThe other is:\n'=((546 * A19) * 100000) +1'\n\nThe other answerers have helped out with how to find out which one grows faster.  Ie, y = mx + b.
943817
[EDIT - DELETED A WHOLE BUNCH OF TEXT]\n\nthat kind of thing is complex to create in a macro form, normally the kind of thing that you'd pay someone to do because i'd imagine it's easily a couple of hours work to write all the code, test it, iron out bugs etc. there *may* be a built in function in excel to do something like this but i wouldn't have thought so - i'm happy to be proved wrong:\n\n----found on t'internet----\nA1:A10 (your list of values)\nB1:B10 (leave blank)\nC1: =A1*B1 (copy thist fomula down through to C10)\nC11: =SUM(C1:C10)\n\nNow to use Solver....\nTools>Solver\nSet Cell: C11\nEqual to the Value of: 1173.76\nBy Changing Cells: B1:B10\nSubject to the Constraints....\n(click the add button and constrain B1:B10 to Binary)\nClick [OK]\nClick [Solve]\n\nExcel will toggle cells B1:B10 between 1 and 0 until it comes up with a combination that sums to 1,173.76\n----end of instructions----\n\nit depends on the setup of your spreadsheet - if it's one huge page that's a jumble of undistinguishable invoices with no reference to who the invoices belong to, it means manually checking the results of the macro for the set of results that applies only to one 'customer'. ideally you'd want a seperate sheet for each customer and then the macro or above method can be ran on whichever sheet/customer the cheque is from.\n\ni dunno about other people on here but i wouldn't spend hours of my time creating such a thing for the sake of 10 points which aren't really worth anything - i CAN tell you that if the above method doesn't do the job that it'd mean creating a loop that will add up every possible combination of totals from the sheet then comparing it each time against the grand total until it gets a 'hit'.\n\ni can't imagine this kind of sorting being practical for huge amounts of figures, probably a list of 20 at most because you could get into some big big processing time otherwise.\n\ni would be interested in hearing anyone elses ideas about doing it?
834986
Use conditional formatting\n\nhttp://www.contextures.com/xlCondFormat01.html
372526
some calculators can do this\n\nmathematica software will do it
697117
Subtract the cells and format it as numeric
351083
In A3, put "=SUM(A1:A2)" or just "=A1+A2"
523638
Put 5 in cell A1\nPut 2 in cell B1\nTo subtract, in cell C1 put  =A1-B1\nAfter enter key, the answer 3 appears in cell C1\n\nYou can test it by changing the numbers in A1 and B1, it will work every time.
757627
=IF(your formula)=0, "", (your formula))\n\nyou could also use the ISBLANK with the IF\n\n=IF(ISBLANK(your formula), "", (your formula))
891988
Multiply that by about 0.458
553854
I came up with eight possible answers.  I'm assuming what you are saying is that each digit must be a prime number (e.g. in the set {2,3,5,7}) It's pretty obvious that the product will end in 5, and neither of the multipliers can end in 2.\n\nUsing an Excel spreadsheet I came up with the following answers:\n325 x 73 = 23725\n337 x 75 = 25275\n355 x 77 = 27335\n375 x 73 = 27375\n575 x 57 = 32775\n735 x 35 = 25725\n737 x 75 = 55275\n775 x 33 = 25575
1025264
pls specify ur question, didnt quite understand it\n\nIf there is "OR" u have to add and if it is "And" u have to multiply.
1111499
If the source number is in cell A1, just type =-A1 in a blank target cell.\n\nAssuming that your mis-entered numbers are all in a column, you can then drag the formula down the target column to replicate.\n\nFinally, if you want to get back to real values instead of fomulas, you can select the target column with the switched numbers and copy it. Then >Edit>Paste Special>Values .
1172805
I would use Data Validation and VLOOKUP in Excel to do this.\n\nType in the 2 lists (for convenience lets start in A1) then add a third column:\nSerial#1          Combo#1          =A1\nSerial#2          Combo#2          =A2\nSerial#3          Combo#3          =A3\n\nMake the lists as long as you need. We created the third column for later; it just copies the serial numbers over to simplify things for the VLOOKUP formula.\n\nNow that the data is input we will need to create a drop-down menu. Since the data is in columns A-C, click in E1 to select the cell and click Data | Validation… In the Allow box choose List and type the range for the combinations in the Source: field (in our example: A1:A3). Now, click on F1 and type this formula:\n=VLOOKUP(E1,A1:B3,2,FALSE)\nIn the parentheses you will have this data: \n-E1 is the criteria you will look up in the array.\n-A1:B3 is the array where the data resides (remember this is from the example, yours will be longer).\n-2 in our formula tells VLOOKUP to pull the data in the 2nd column that matches our criteria from the 1st column.\n-False tells VLOOKUP to look for an exact match.\n\nWe have now created the Serial Number lookup that returns the proper Combination. To lookup the Serial Number from the Combination, we just do the steps again.\n\nClick in E2, choose Data | Validation… Again, in the Allow field choose List, but this time we need the combinations in the drop-down (B1:B3); click OK. The formula for F2 is almost the same:\n=VLOOKUP(E2,B1:C3,2,FALSE)\nThe only differences is that the criteria and array are shifted; the criteria down one row and the array over one column.\n\nIf you wish to hide the rows that contain the array, just right-click on the column headings and choose hide.
1029069
186,000  ~~~~~100\n---------- x        ------------   =   ----------/12 = your answer\n  100     ~~~~~~.15\n\nIn other words, multiply 186,000 by .15, and divide your answer by 12.\n\n(the format won't allow me to type the formula as it should be.  Please disregard the "~~~~~~~"