In excel, can i have a group of numbers and have a formula add some numbers to get a known #?
364953
put all of your numbers in separate fields ie. A1 [15] A2 [20] etc etc.   Then for your total in another field, say B1 put the equation  [A1 + A2 + A3] . now B1 = Sum of the fields you choose
731003
ok.. um..if i remember correctly you would multiply 10 (the number of digits possible) x 4 (the number of digits) that makes 10,000 different possiblitiies... can i name them? probably...but wow.. that's a lot of time and energy.
550410
There are a lot of software libraries that do that:\n\nhttp://tinyurl.com/k9zah\n\nincluding some for Excel:\n\nhttp://tinyurl.com/hrda7
789077
in excel all you have to do is to put = before any equation you want to solve and then press ok \nyou can use squares instead of the no.s
321857
Use the good formula CountIF.\n\nOr\n\nYou can use also SumIf.\n\ne-mail me
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...
1103350
excel is not that usefull for this. You basically have to write a VBA program that will go like this:\n\nif cell-value=111222 then cell-value="johnny"\n\nand so on for every contact you have. While thi is not hard there are better ways to do this. There are Address book programs that let you search by any field.
490179
If Ed answer was not the one you liked, you may see the "Value" in Excel Help, f this is what you asked for,\nThis Value is reffered to the result of a cell function.\nMeans\nWhen you enter =4*5 in a cell this "=4*5" is the cell content, while the "20" that appears in the cell is the "Value" of this cell\n\nHope this is what you asked for..\n\nXLMan
661261
You could use conditional formatting on the cells where you are entering your data.  But you actually don't need to do conditional formatting, it's just that you can get smoother more interesting effects if you do.  An easier way might be a simple formula.\n\nIt sounds like you are entering data that uses Case numbers, but if you have already entered a case, you don't want to do it again.  Obviously you could just search the case number column to see if it already exists and if so, then skip entering it.  But a more automated way would be easier.\n\nThe essence of what you need to do is use a formula to tell you if what you just entered already exists in the rows above. (To use your example, does case 24 exist already in the rows above A27?)\n\nYou could insert a (temporary) column to the left of what you are typing in.  In that column you would enter a formula to count the number of instances where the case number you just entered already exists above.  Usually the result would be 1, sometimes 2.\n\nLets say you are on row 27 and your case numbers are in column B, and your counting column is column A.  Lets assume your data starts on row 2 at the top of the spreadsheet.  Your formula for cell A27 would be:\n=IF(COUNTIF($B$2:B27,B27)>1, "Exists Already!", "")\n\nNotice the $ signs in the Countif formula.  The formula range will adjust as appropriately as you copy it around.  You want to get this formula on every line next to every case number so that it can alert you if it seen there is more than once instance.\n\n(Actually the Data Validation mentioned below is a better solution because it will prohibit you from entering the data.  But it's all the same principle. Just more elegant because you don't need to insert a new column.)
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.
461876
Use Word's integrated equation editor:\n\nInsert > Object > Microsoft Equation 3.0\n\nThis will launch an equation editor that will allow you to put in almost any mathematical symbol/number, etc.\n\nHope this helps.
444067
Put this in C1:\n\n=(12-A1)-(12-B1)\n\nHave the cell formated to time.
1009264
Microsoft Excel only keeps a numeric value with upto 15-digits of percision, which means any number greater than 15 digits is converted to scientific notation, and the 15 most significant digits are retained.\n\nYou can, however, display a larger number by displaying the number as a "text" value, by placing a single quote before the number.  This text number will not be able to be used within calculations.
771506
It could be any number between 0000 and 9999. If you need a list, start by writing down 0001, then 0002, then 0003, until you get to 9999. There's your list.
955614
in excel you would use formulas such as =a1*3 in each cell to make the effect work from a starting number.  In HTML, you would actually use an XML table and/or some kind of scripting such as vbscript or javascript.
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))
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.