Threads Replies Last Post 125 Pages: <<  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  44  45  >>   formulas/function Hi there! Im wondering if you could help me out as im trying all kind of tricks to make what i want it to work, i have tried =if(or(a1>b1,a1<b2), "x","y") function, (b1=01/01/2005, b2= 31/12/2005) it will work but if no date has been input then it I 'm looking for fornulas/function that will help me with my work, see below: between 01/01/2005 and 31/12/2005 = "x" between 01/01/2006... 2 10.07.2006 18:03:21 Linking templates together I was wondering how do I go about linking the numbers in various excel templates together so that a change in one template will be reflected in another. Ex. I have a income statement template and a balance sheet template, if I make a change to the income statement I would like the balance sheet to reflect the change automatically. How is this possible?... 4 10.07.2006 16:24:57 formulas/function Hi there! Im wondering if you could help me out as im trying all kind of tricks to make what i want it to work, i have tried =if(or(a1>b1,a1<b2), "x","y") function, (b1=01/01/2005, b2= 31/12/2005) it will work but if no date has been input then it still show x 'm looking for fornulas/function that will help me with my work, see below: between 01/01/2005 and 31/12/2005 = "x" between... 3 10.07.2006 15:14:57 ATTN: Works wdb files to Excel 2003 converter query Hi, I need to convert MS Works .wdb files - unknown version - to Excel 2003. Do you have or know where I can download a free converter. It is only needed for a couple of files. TIA SeeAll ... 2 09.07.2006 20:28:43 Task Pane How can I get the task pane to come up in Excel?... 2 09.07.2006 18:16:13 Add formula to Macro??? How do I integrate a long custom formula in a macro ? The formula will be used to manipulate a column of data. Do I record myself actually typing the formula while I record the macro? Is there an easier way? Thanks ... 4 09.07.2006 13:29:42 Adding 6 months to any given date is it possible to add 6 months to a given date? i.e. if in cell A1 the date is 04/05/03, then cell B1 should return the date plus 6 months ie 04/12/03. the only way ive been able to get something near is by adding 182.5 which is half a year in days but this obviously doesnt account for the different months having varying amounts of days. Any Ideas? Regards Hoyt... 8 09.07.2006 10:14:01 Sales Tax Calculation Hi, What function or calculation could I use in a spreadsheet to calculate the price of an item minus the local sales tax so that in the end the final price would be a whole number. I would like to enter the local tax rate in percent so I could figure out what the price for an item should be so in the end the final price is $5, $10, $15 etc. Using Excel 2000. Thanks, Linda ... 10 09.07.2006 01:25:59 In Excel, gridlines won't print--File,PageSetup,Sheet,Gridlines-- I want to PRINT gridlines: File,PageSetup,Sheet,Gridlines--but no joy. Gridlines DO show on the monitor but not on the Print Preview or on an actual Print.... 4 09.07.2006 00:45:01 Excel: find Window in which I can freeze panes I cannot find the Window in the toolbar on which I can freeze panes, i.e., freeze column heads to prevent their scrolling out of view.... 4 08.07.2006 21:55:33 Display contents of cell in another cell as part of text string? How can I display the contents of a cell in another as part of a text string. Such as... "The answer is "B4"" where B4 is the contents of cell B4? Thanks ... 4 08.07.2006 18:44:27 Lotus had buttons (icons) for first & last cell does excell? Lotus used to have two icons, one that took you to the first cell of the sheet and the second that took you to the last used cell of the sheet. ARe there icons in excel for this?... 6 08.07.2006 16:39:28 edit directly in cell in Excel 2007 Hi, in Excel 2003 I disable the "Edit directly in cell" option so that when I double-click on a cell that has a formula link ='Sheet1'A23 the cursor goes to cell A23 of Sheet1. It is very useful for me to nabvigate among my formula. I'm searching the same option in Excel 2007 but I really cannot find it.. Thanks a lot! Andrea... 6 08.07.2006 14:50:03 How can i make an action Plan? please farwad me a detail excil table... 2 08.07.2006 12:42:56 Excel hangs on calculation Ok, I got a three sheet excel file that I cannot get to run calculation on. Sheet 1 has ~4000 rows, 10 columns. Each row has a VLOOKUP and two INDEX statements. Sheet 2 has ~8000 rows, 4 columns, the data is imported via SQL query. Sheet 3 has ~4000 rows, 4 columns, this data is imported from a text file. The VLOOKUP command on Sheet 1 references Sheet 2. Each row on Sheet 1 has t... 3 08.07.2006 10:25:46 1:1 as the Array using the MATCH function Hello, I am working on an Excel course from OzGrid. One of the problem/examples defines the MATCH function Array as 1:1. In my ignorance I expected something like A1:G50. I can't find in Help an explanation of what "1:1" defines. I will appreciate some guidance. Thanks Bob ... 5 08.07.2006 09:31:25 Convert function not working Sir/Mam, I tried this function =CONVERT(2.5, "ft", "sec") but it is not working. it is giving #name? I m using office 2003. yours Rao Ratan Singh... 4 08.07.2006 08:32:52 newbie protection question How do I pretect sheets in such a way that users can input data but can't change formulas, macros etc? Thanks John... 12 08.07.2006 02:09:01 system errror &H8000FFFF When i open excel in office 2003 that time it's showing error system error &H8000FFFF(-2147418113).Catastrophic failure If I press ok out of memory If I press ok Then only exnel sheet opened solution of this problem Hari... 2 08.07.2006 01:01:01 Is there a way to copy every 4th cell I am working with imported data and I need the information in every 4th cell for a different worksheet. How can I do this.... 5 07.07.2006 21:03:29 when importing .txt files can I separate the data horizontally I have to import a .txt file from a database query into an excel spreadsheet and I can't get the data to format properly. It comes in this format from the query... 1111 PHYSICIAN OFFICE RP 111 WEST ST 880 555-1212 SMALLVILLE,... 6 07.07.2006 18:12:57 How do I round time to the nearest quarter of an hour I am not too understanding of excel to any great extent. But I need to round time to the nearest quarter. Example 8:11 to 8.25 4:41 to 4.75... 7 07.07.2006 17:36:02 unable to enter numerical data in cells I Have just activated excel 2003. I am unable to enter data into any cells. I am also unable to enter information into microsoft word. How do I rectify this problem? I am familiar with excel 2000 and never encountered any problems.... 2 07.07.2006 17:19:52 Max number of worksheets in a file Is there a limit on the number of worksheets that can be contained in a single Excel file?... 7 07.07.2006 16:20:15 Help with IF formula Hi everyone. Someone on here always has an answer for my question, so thanks in advance. I am running XP Pro SP2, and Office Pro 2003. Column A is for quantity, and the quantity can be positive or negative. Column H is for individual pricing, and Column I is for the price extension (i.e. A*H). Column I is blank unless there is a number to be displayed. I have the following formu... 7 07.07.2006 16:09:41 125 Pages: <<  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  44  45  >>