Please Help, I am desperate! EXCEL FORMULA?
829503
I accept the challenge for the fun of it.\n\n...will get back to you.\n\n\nOK.  in cell G5, based on what you describe, the formula is "=VLOOKUP(+E5,$B$2:$C$5,2)"  Note the dollar signs in the formula referring to cells B2 and C5.  This will allow you to copy cell G5 into G6, G7, G8, and so on if you have more values in column E.\n\n\nNOTE: In column B2 to B5 are the numbers 0, 32, 63, and 94 respectively.  In column C2 to C5 are the words Freshman, Sophomore, Junior, and Senior respectively.
1083459
Use this formula:\n\nSn=n/2[t1+tn]\n\nwhere\nSn --> ur required sum\nn --> no. of terms in the given progression \nt1 --> first term (in ur case: 3)\ntn -->last term (in ur case: 803)
837908
click here:http://en.wikipedia.org/wiki/Microsoft_Excel
672487
Yes, VLookup is what you need\nPaste this function in B column in sheet Y\n=vlookup($A1; X!$A:$D; column(); false)\nwithout these spaces..and fill down and right\n\nXLMan
510597
its very simple in the cell where u want to calculate the amount just write down the formula of =sum(cellrangestartsat:cellrangefinished)\nif u have any queries jst give me mail, mokkksh@yahoo.co.in
668871
You may have to write that fomula out manually. \n \n=OR(AND(A1,NOT(B1)), AND(NOT(A1),B1))
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.
411443
this is the best Excel site I've ever found on the web. Lots and lots of tutorials from beginner level to expert. \n\nhttp://www.MrExcel.com\n\ngood luck
311874
if cell A1 has a value of 50, and cell A2 has a value of 75, and you were looking to have cell A3 have a value of 67%, you would type in cell A3 the following formula:\n\n=A1/A2\n\nwhen you press return, you should get a value like 0.666667 or something similar.  Right click on that cell, and select "format cells" from the pop-up menu.  On the number tab of the format cells dialog, select the "Percentage" category and click OK.  You're done.
675408
The last formula works because you are evaluating the range with an array formula "countblank"\n\nin the original formula you are trying to evaluate a range of values in the condition section of your "if" formula wich is not an "array" fild. This can be done if you conver the formula to an array formula.... Simply hold shift+ctrl when you enter the formula....\n\nthe formula will appears like this\n\n={ IF ( OR ( $C$49:C64=0 ), " ", C64-C63 ) }
572979
It is pretty simple in excel...\n\nPut your equation into A1 (without the y), except substitute x for B1\nfor example y=2x+7 becomes =2*B1+7 (make sure you have the '=')\nNow, put the x values in the B column, and fill down.  The A column should now be the answers to your equation (y).\n\nTo graph this select the A column, go to the "insert" tab and select "chart".  Select line graph and pick the one you like the most.  This should put column A (the y values) on the y-axis and column B (the x values) on the x-axis.\n\nYou will have to select the range for your values and title the graph and axes, but you can get that.\n\nIf you don't completely understand, play around with it for a little while, you'll figure it out.
688944
View source of the that page.\nYou will see the formulas.
965931
u can do it by sorting, filtering i know , other participants already gave u that so i'm including this one\n\nfor largest value \n=MAX(B1:B3)\n\nnote the reference value of this cell in the left top \n\nfor corresponding day \n=LOOKUP(cell reference value of max,B1:B3,A1:A3)\n\ni think it's the best answer
974937
please complete the equation
709713
You can simply use an "IF" statement.\n \nLet's say in A column some cells have values & some don't - for the one that has a value (non-blank), you'd like put the number "2" next to it (in the B column), here the formula -\n\n=IF(A1<>="",2,"")\nThis means if A1 is not blank, then put 2 in B1, otherwise leave it blank.
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.
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.