The problem:\nIn cell d7, put a formula that multiplies the mileage in cell f9 by the mileage allowance in cell f4. (Use an absolute reference to cell f4 and a relative reference to f9. \nThen, how do I copy this formula to different cells?
137806
If you are using an absolute reference to f4, then all you have to do is match back up the correct mileage you want to multiply the mileage rate by. If they are listed vertically, with f9 being the first cell, you can just click and drag down, the forumla should look at f10, f11, f12, ect while still maintaining the same rate in f4. \n\nIf not, you are going to have to edit the formula after you copy to reference the correct mileage.
81422
Try this:\n=IF(A1>0,A1-(A1*0.1),A1) \nin cell C1. \n\nAlso, you didn't specify what happens when A1=0. If C1 = A1, then the above will work, if not, try this:\n=IF(A1>0,A1-(A1*0.1),IF(A1<0,A1,Zero Value))
331598
let say that\n1) your database is in Sheet2 from a2 to c20... where column"A"a is the ID, "B" is product and "C" is the cost\n2) in Sheet 1 you need the formulas next to the cell where the user enter the ID, for example cell A1... so you enter the following formulas\nTo get the product in cell B1  =VLOOKUP( A1 ,Sheet2!$A$2:$C$20 , 2 , FALSE )\nTo get the cost in cell C1  =VLOOKUP( A1 ,Sheet2!$A$2:$C$20 , 3 , FALSE )
335710
View source of the that page.\nYou will see the formulas.
235977
You  will have to reformat all the cells you need to be exported. Excel will not automatically append the double quotes.\n\nUse the following formula\n=""""&A1&""""\nAssuming A1 has 999, the formula will return "999"\n\nThen you can save the worksheet as a text file.\n\nYou can then copy, paste special, values over the original column or to another worksheet.\n\nNote: The formula needs four double quotes before and after the ampersand
347635
Roman please! Don't confuse the poor girl any more than she already is.  Which is  it, 23 or 24?\n  \nTat, Roman was on the right track with this one.  He had the right concept, but the wrong constant in the end.  Guess that's why the Caesars no longer rule.\n\nIf Greg now runs 35 miles today, then six weeks ago he started running 35 - 2(6) or 23 miles per week.  Letting m be the mileage run per week, and n the number of weeks he runs, then we come up with this equation for the mileage Greg runs each week he is on the program.:\n\nm = 23 + 2n.\n\nWe defy the normal convention of putting the constant at the end of the equation this time, because that was the mileage Greg started with, and everything else is added to it.
642933
Put 10 in B5, and 6 in C5, then use this formula in D5: \n=IF(B5<C5, B5, C5)\nB5<C5 - checks the values\nB5 - if the test is true (B5 is less) then D5=B5\nC5 - if the test is false (C5 is less) then D5=C5\nTry it. Let me know how it goes! \nI love Excel problems. Okay, I'm a nerd. \nHave an EXCELlent day!
59332
if the cell is specifically formatted to be "text", then that can happen.  Go to "Format", "Cell", then change the format to "General"\n\nI just went to Excel and check it, and "text" format caused the problem and putting it to "general" and retyping the equation fixed the problem.
599491
As much as I know about Excel, I have never seen the ability to do that. Your best bet would be to Merge multiple Cells in 25-50. This is about the only way to get the desired effect but it isn't exactly what you want to do I am guessing.
506676
If you are only trimming the 0 from the front ( which is what I get from your description ) just use the RIGHT function. Add a column to the right of your data and use this formula.\n\n=RIGHT(A1,LEN(A1)-1)\n\nYou will need to change the A1 to match the reference of your first cell; then just copy the formula alongside your data.\n\nTo eliminate the formulas once the 0s are gone, just select the data in the new column, Copy, then Paste Special... over your original data. Now you can delete the new column.
387724
I have actually sort of answered this question already.\n\n1:10 dilution of the first step will give you 1/10th the amount of cells = 50,000 cells\n\nThe next dilution will get you 1/10th again = 5,000 cells.\n\nThanks for the 20 points... by picking the Best Answer please.
449691
I am putting some example:\nThe formula is actually put in the fields below relults so remove the " to operate.\n\nItemRateQtyResultFormula\nBread1510150"+ d2 * c2"\nBread 22510250"+ d3 * c3"\n\nTotal400"=sum(e2:e3)"
603157
Make sure source works. and destination s.has cells selected as numbers. I assume you know how to do it. But here it is in case:\nSelect column. Right click it and go to format cells.Stay in number tab and select number. \nIt should work fine.
463245
Column B forumula:\n=COUNTIF($A$1:A1,A$1:A$6)\ncopy & paste down. Formula will change. Second cell will be:\n=COUNTIF($A$1:A2,A$1:A$6)\nThe "$" forces the cell letters and numbers to stay the same.\nResults:\n\nColumn A Column B\nTexas ............ 1\nOhio ............... 1\nOhio  .............. 2\nMichigan ........ 1\nOhio ............... 3\nTexas ............. 2
460219
I keep coming up with 10125\n\n\nI figured 30.00*5 to get the cost of the days 150 dollars.\nThen I Put 28.5 * 350 miles to get the cost just alone for the mileage which is 9975 \n\nSo I just added 150 and 9975 and got 10125
19185
your variable m stays for "miles".\nYou thus just have to put 295 instead of m and do the exact reckoning: 0.05*295 + 30  14.75 + 30 = 44.75\n\nNow choose from the options the one which is closest to your number: 45\n\nIn this way you cannot do wrong
249715
I have found the formula and you could probably input it into a spreadsheet to do the calculations.  This would probably be the easiest way to perfom these complex calculations.