Could somebody explain to me what is so difficult about making functions in excel?
103869
To be able to use a tool to accomplish a task, you need to know about the task.  Ignorance of the task is one fundamental problem that instructors trying to introduce the concept of functions have to face.\n\nA good way to do it is take up a task (say calculating interest), let them know the parameters involved (what we call variables in math).. and how the result is derived manually.  \n\nNow, if they are made to understand that excel/spreadsheet is a tool that would enable them to accomplish that same task .... may be they would be able to get along .....
511921
You  will have to reformat all the cells you need to be exported. Excel will not automatically append the double quotes.\n\nUse the following formula\n=""""&A1&""""\nAssuming A1 has 999, the formula will return "999"\n\nThen you can save the worksheet as a text file.\n\nYou can then copy, paste special, values over the original column or to another worksheet.\n\nNote: The formula needs four double quotes before and after the ampersand
61805
try using this site. its a tutorial. http://www.usd.edu/trio/tut/excel/
697117
Subtract the cells and format it as numeric
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.
970192
I thought I was pretty handy with excel, but I have no idea what you're asking! Do you mean the options pop-up you get if you right-click on a cell? Or Insert > Function? (on the pull-down menu, or click on the 'fx' button just below your toolbar/s). Perhaps if you clarify your question you might get a more helpful answer than I feel I can give you.
242526
I don't have a real answer for you.\n\nBut you can either use formulas in each cell, or apply Visual Basic Macros. I have done a lot of VBA, but only with Word. VBA is pretty easy - except you need to know the names of the various objects. But sample macros are floating around and Microsoft is fairly good about having details on this sort of thing.\n\nIn fact, now that I think of it, you might be better off writing the whole thing in Visual Basic and skip Excel. (Which, of course, does you no good if you don't have VB.)
855738
MS Excel has tons of great formulas.  Have you thought about using that.  Also, not sure what sort of database application you're using but formulas can usually be programmed into them.
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.
360717
let suppose in excel\n\nuse a line of code at top\n\nApplication.ScreenUpdating = False\n\nthis will simply disable screen refreshing when working in the codes so it will improve the speed.\n\nalso avoide using nested loops\nalways use long or integers don't use double or single variable types\n\nand remove the duplicate loops
830317
f1>f3>f2>f5>f4\nJust replace the variable n in  Excel's function and compare the result.
925219
Ok This what you do. Micorsoft Excel Can do it for you perfectly well. All you need is to simplify the fomular inwhich you want to use in making your calculations so that everytime you type in a number you will get the totals without craking your head too much. \n\nExcel is what you need. \n\nThanks
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.
999231
use the Macro Recorder to code the procedure you want...then you can convert it to VBA (Visual BASIC for Applications) and edit it.
301989
Insert -> Object -> Microsoft Equation (or Equation depending on version)\n\nIt will then bring up a pallet with formula functions.  Closing this sub window will insert the equation you create into your document.
596850
Do these words have only numbers? or do they have extra letters?\nIf the numbers you need to convert are in the beggining of the cell, use the Value function\n=value(A1)\nassuming that the cell you want to convert is in A1\n\notherwise\nsend me you e-mail address , and I will be happy to help\n\nI am the XLMan
421831
Is not easy, but it is not imposible... I write a lot of macros in excel and i've run in that situation several time. I learned how to crack the VBE password.\n\nIf you search the web, everybody want to sell you a prduct to do that...\n\nif this is just a one time event for you, you can send it to me, i'll crack it and re-send it to you with out the VBE password\n...