In MSExcell How to convert 100 in Cell A1 to One Hundred in B1 by formula?
961849
try this lnk..\nhttp://www.meadinkent.co.uk/xlnumberstext.htm
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"
202107
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))
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.
697117
Subtract the cells and format it as numeric
10776
Insert the value "-1" into a cell.  Copy it.  Highlight all the cells you want to change.  Right Click>Paste Special>Multiply.  This will multiply all cells by -1.\n\nYou can always just hide the row/column and create a viewable row/column that is that (-cell).
275977
For even numbers use formula\n=IF(MOD(Cell coord with original number;2)=0;Value you want to perscribe the active cell)\n\nFor odd numbers:\n=IF(MOD(Cell coord with original number;2)<>0;Value you want to perscribe the active cell)
1185281
Goto Tools Menu > Macro > Visual Basic Editor (Alt + F11)\n\nType this in exactly...\n\nPrivate Sub Worksheet_SelectionChange(ByVal Target As Range)\n    Sheet1.Cells(1, 1) = Sheet1.Name\nEnd Sub\n\nSheet1.Cells(Row, Column)\nRow = Row Number\nColumn = Column Number (A = 1, B = 2, C = 3, etc)\n\nThis will change the text in the cell everytime you change the name of the sheet and click anywhere in the sheet.
995900
It depends on how you have your other amounts organised.\n\nIf you have a column or row that is for periodic end amounts, eg, weekly totals.  You can set up a range for these.  For an example, assume the column A holds the weekly totals.   They start from A1 and finish A52.\n\nCreate a new cell and type this formula, without the quotes:\n'=sum(A1 : A52)'\nThats it.
366534
It completely depends on where you are using this formula, is it in Excel? A program? What language?\n\nWe need more info.
834986
Use conditional formatting\n\nhttp://www.contextures.com/xlCondFormat01.html
130036
1. Start Microsoft Excel\n\n2. Before you type fractions in cells, preformat the group of cells that need to be displayed as fractions. Select the cells where you want to enter fractions, and then select Cells from the Format menu.\n\n3. Click Fraction in the Category list, and then, from the list on the right, select the type of fraction that you would like to display. Click OK.\n\n4. Now you are ready to type fractions in these preformatted cells. To type fractions in cells, just type the numerator, followed by a slash (/), then followed by the denominator—do not type spaces.\n\na. For example, 1/2 would represent one-half, as would 4/8 (Excel reduces fractions to their lowest terms). If you need to type a whole number and a fraction in one cell, type the whole number followed by a space, and then type the fraction (numerator, slash, denominator).
830543
{=SUM(IF($A$2:$A$11 = DATEVALUE("11/29/06"), $B$2:$B$11, 0))}\n\nThis example (an array formula, so hit CTRL+Shift+Enter when you finish typing it instead of just Enter (don't type the brackets - { } )) sums the contents of Column B  for every instance the Column A contains 11-29). Just modify it to match your cell references and it should work just fine.
668871
You may have to write that fomula out manually. \n \n=OR(AND(A1,NOT(B1)), AND(NOT(A1),B1))
1059707
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.
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.
828527
Create a table in Excel with the first column containing the number and the second column containing the word related to the number.  Then use vlookup to read in the figure and output the word.\n\nFor example, assuming that you want to replace values from 1 to 5 with words, your lookup table is as follows (with a range name of figure_lookup:\n1One\n2Two\n3Three\n4Four\n5Five\n\nCell A1 contains the number 1, then your formula is =VLOOKUP(A1,figure_lookup,2)  where A1 is the value being looked up in the table called figure_lookup (could also use cell references such as B5:C9), using the 2nd column.\n\n\nAnother option:\nOr a much more elaborate way to do this is with Visual Basic.  Details are at:  http://www.ozgrid.com/VBA/ValueToWords.htm