in excel i need a formula for     =IF (A2=A A=10)?
470569
The formula would be: =IF(A2="A", 10)\n\nThis would be pasted into another cell, like B2 for example.  Thus, if A2 is A, then B2 would display a 10 - if it is not, it will display FALSE.\n\nIf you don't want FALSE to appear, change the formula to: =IF(A2="A", 10, 0)  You can substitute the value of 0 for whatever you want the cell B2 to display if A2 is not A.
697117
Subtract the cells and format it as numeric
26787
If you're talking about Excel from Microsoft, heres a couple pointers\n\n1) every formula starts with an equals sign '='\n2) there are countless formulas you can use, your best bet would be to click on the '=' in the upper left of the window and a box will pop up to help you.
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")
1120168
Equals another negative number
121013
if it is in binary, 1 + 1 = 10
881167
why don't you use an IF() formula with the same criteria as the ones used for conditional format. It will return the x value when the conditions are met and the Y value when not.
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.
1177830
You have to put this if condition\n\ngoto b1 cell and put this formula =if(a1="ON",1,if(a1="OFF",0,"EMPTY"))\n\nif you can't read full formula please move your mouse pointer over it. then it will be displayed full.\n\nso when you put ON in a1 cell, that will display 1 and when you put OFF b1 cell will display   0   if a1 cell remains empty, then b1 will display "EMPTY"
668871
You may have to write that fomula out manually. \n \n=OR(AND(A1,NOT(B1)), AND(NOT(A1),B1))
339223
Use the Median function.  Go to the cell you want the answer to appear in and type\n\n=median(xxxxx)\n\nwhere xxxxx is the location of the cells with the numbers that you described.  For example, if your numbers are in cells A1 through A7, your formula would look like\n\n=median(A1:A7)\n\nIf your numbers are in nonadjacent cells, you can separate them with a comma, like\n\n=median(A1:A4, A6:A8)\n=median(A1, B1:B5, C2)\netc.\n\nYou don't have to type the numbers (i.e. 10, 10, 20, 30, 30, 30, 30) in the formula - just use a reference (i.e. A1:A7) so that if you change any of the numbers, your median will automatically recalculate.
928231
8x-10x > -11-1\n\n-2x > -12\n\nx < 6
332255
=IF(OR(AND(A1>=1,A1<=12),\n       AND(A1>=25,A1<=36)),1,\n   IF(OR(AND(A1>=13,A1<=24),\n         AND(A1>=37,A1<=48)),2,""))\n\n\n(make sure it's all on one line with no spaces)
639517
Excel's IF function provides some simple decision-making capability to a worksheet. The IF function accepts three arguments:\n\nThe condition being evaluated (should result in either TRUE or FALSE) \nThe value to display if the condition is TRUE \nThe value to display if the condition is FALSE \nThe formula below, for example, returns 1 if cell A1 contains "A". If cell A1 does not contain "A", the formula returns an empty string.\n\n=IF(A1="A",1,"")\n\nFor more decision-making power, you can "nest" IF functions within a formula. In other words, you can use an IF function as the second argument for an IF function. Here's an example:\n\n=IF(A1="A",1,IF(A1="B",2,IF(A1="C",3,"")))\n\nThis formula checks cell A1. If it contains "A", the formula returns 1. If it doesn't contain "A", then the second argument is evaluated. The second argument contains another IF function that determines if A1 contains a "B". If so, the formula returns 2; if not, the formula evaluates the IF function contained in the second argument and checks to see if A1 contains "C". If so, it returns 3; otherwise, it returns an empty string.\n\nExcel allows up to seven levels of nested IF functions. The formula below works correctly, but Excel will not allow you to nest the IF functions any deeper than this.\n\n=IF(A1="A",1,IF(A1="B",2,IF(A1="C",3,IF(A1="D",4,\n IF(A1="E",5,IF(A1="F",6,IF(A1="G",7,IF(A1="H",8,""))))))))\n\nThe sections that follow present various ways to get around the limit of seven nested IF functions. Be aware that these techniques may not be appropriate for all situations.
65173
Paste this formula in the third cloumn\n\n=VLOOKUP(A1,B1:B4,1,0)\n\nAll the matching cells will get their values printed whereas the unmatched cells will contain #NA
342762
x2+5x-2x-10\n\n*answer*\n\nx2+3x-10
540085
(a-2)(a+2)  \n(difference of squares)