Why doesn't work this formula in excel: =TA_ADX(C2:C25;D2:D25;E2:E25;14) ??
347042
I just looked up the Add On.  It looks very good.  I know what might be your problem.\n\n(1)  Click on the cell to edit the formula.  \n(2)  Press Ctrl-Shift-Enter\n\nStep 2 will insert the {} which you need for an array function.  If this does not help not sure what the problem is without seeing the entire formula.
586461
I thought the istext formula would work but they don't.\nHere's another way to solve this issue. Assume the cell to test is in A1, enter the following formula in another cell:\n\n=IF(ISERROR(LEFT(A1,1)/1) ,"yes","no")
916539
1.  Open Excel\n2.  On the top tool bar click the question mark\n3.  In the Office Assistant text box \ntype in\nCalculate the difference between two dates\n\nYou will be given the step by step instructions.\n\nk\np.s.  Use the Office Assistant for \nlots of functions \nincluding getting all sorts of formulas.
976275
2x + 28 < with a line under it _ <_   6x\n\nsorry don't know how to add that special character in, but it is only one thing like the +\n between the 28 and 6
66748
Well this is easy, what you have to do is put in the values as follows:\n\nA1 = 10000\nA2 = =(A1*0.25)+A1\nA3 to A5 jus drag the column in A2, this will compute the percentage of each column just above the column with the formula, and give the result you want.\n\nI hope this is the solution u were looking at.\n\nRegards\nChris
408737
Need to use the product rule here:\n\nd/dx(1/2*tanxsinx)\n\n= [d/dx(1/2tanx)]sinx + 1/2tanx*d/dx(sinx)\n= (1/2sec^2x)sinx + 1/2tanx*cosx\n= sinx/2cos^2x + sinx/2cos^2x\n= tanx/cosx
208575
With MS Excel, enter your equation as "=1000*2.46*0.00000000001", then you would get the result. But it really depends on what you like to see. My MS Excel gave me a answer of 2.46E-08, which means 2.46 x 10 to the power -8. If this isn't the expression that you are after, then here is the answer: 0.0000000246.
964099
Just go to the Cell that you want the total in.\n\nType +sum(d2..d6) where d2 = your first cell to be added and d6 = your last cell to be added.\n\nYou could also use the AUTOSUM button on the top toolbar.\n\nHighlight the cells you want added and hit the button.\n\nHover your cursor over the buttons till you find it.
241133
It fixes the column or row reference.  \n\nFor example:\n\nLet's say you put "=a1+b2" in cell c2, then copy that to c3.  In cell c3, you would get "=a2+b2".\n\nOn the other hand, if you put "=$a$1+b2" in cell c2, then copy that to c3, you would get "=$a$1+b3" in cell C3.\n\nYou can use the $ in either the row or column part of the reference.  Another example:\n\nIf you put =a1+b2 in cell C2, then copy that to cell d3, you would get =b2+c3 in cell d3.\n\nIf you put =$a1+b2 in cell c2, then copy that to d3, you would get =$a2+c3.\n\nIf you put =a$1+b2 in cell c2, then copy that to d3, you would get =b$1+c3.\n\nBest way to see how it works is to play with it some.
110093
Copy then paste the value only.  From Excel Help:\n\n"Replace a formula with its result\nYou can "freeze" a formula so that it no longer recalculates by replacing a formula with its calculated value. If you want to freeze only part of a formula, you can replace only the part you don't want to recalculate.\n\nReplace a formula with its calculated value\n\nCaution   When you replace a formula with its value, Microsoft Excel permanently removes the formula. If you accidentally replace a formula with a value and want to restore the formula, click Undo  immediately after you enter or paste the value.\n\nSelect the cell that contains the formula. \nIf the formula is an array formula, select the range that contains the array formula. \n\nHow? \n\nClick a cell in the array formula. \nOn the Edit menu, click Go To. \nClick Special. \nClick Current array. \nClick Copy . \nClick Paste  on the Standard toolbar. \nClick the arrow next to Paste Options , and then click Values Only. \nReplace part of a formula with its calculated value\n\nCaution   When you replace part of a formula with its value, it cannot be restored.\n\nClick the cell that contains the formula. \nIn the formula bar , select the portion of the formula you want to replace with its calculated value. When you select the part of the formula you want to replace, make sure to include the entire operand. For example, if you select a function, you must select the entire function name, the opening parenthesis, the arguments, and the closing parenthesis. \nTo calculate the selected portion, press F9. \nTo replace the selected portion of the formula with its calculated value, press ENTER. \nIf the formula is an array formula, press CTRL+SHIFT+ENTER. "
603804
apply formula for it\nits easy
813501
Set cell A1 to 5:34:55 and some other cell to:\n\n=(HOUR(A1))*60+MINUTE(A1)+ IF(SECOND(A1)>30, INT(1+ SECOND(A1)/60), SECOND(A1)/60)
165476
How about (a+c)/(b+d)  ? more interesting!!\n\nbtw this only work when a/b != c/d
653602
Do you have Excel, if you do, then Excel can do that.  I think the formulas are self explanatory but if it isn't obvious to you, a Google search should turn up on how to do this in Excel.
358817
- Open MS-Excel;\n- Start adding all the equations you want;\n- Save the file once done...\n\nEquation Example:\nA simple adding equation:\n- type the number 1 in cell A1\n- type the number 2 in cell A2\n- type =A1+A2\n\nand you are done\n\nTo type, click on the cell with the mouse, then type, or double-click on the cell and type\n\nTo confirm text and exit editing it, hit the Enter button\n\n_________________________\n\nTips:\n=====\n- you can use any of the following: + - * /\n- to start an equation, it must start with the = sign\n- ^ is the power sign\n- pi is used in geometry [EX: type pi() to get its value]\n\n\nHope this helps a little...
885883
for example\na/b\n---- = ad/bc\nc/d\n \n\na/b + c/d = (ad +cb)/ad\n\na/b -c/d =( ad- bc) /ad\n\n(a/b)(c/d)= ac/bd\n\nx
864721
I assume you mean in MS Excel????????\n\nPutting a '$' in front of the reference will force the reference to look at exactly that place and not at a relative location.\n\ne.g. $A23 will mean that every cell looks at column 'A' regardless of whether column A is 5 or 55 columns away, but the row reference will be relative to the row in use.\n$A$23 will force the reference to point to exactly that cell.\n\n///