Hi Peter =INDIRECT("C:\Month" & A1 & ".xls") HTH Cordially Pascal "Peter" <Peter@discussions.microsoft.com> a �crit dans le message de news:045B88B8-30B0-47EF-9801-C9E8C55B5877@microsoft.com... > Dear All, > > Is there a way of including a formula in a path. > Every month I have to repeat the same calculations on different file eg: File name month 1, month 2,3,4 etc. I have to change the path name many times. I'd like to be able to say +c:\Month +a1 etc where a1 is the month number. > > The find and replace function doesn't work for a number of reasons. I tried concatenate but that involves fiddling around to get back to a path formula. > > Any other ideas? > > Many thanks

0 |

7/1/2004 12:50:41 PM

Is the following possible in Microsoft Excel, and if so, how? Let's say I have a worksheet with the following cell values: A2: 5 A3: 7 A4: 10 A5: 2 A6: 7 Now, what I'd like to be able to do is have a cell, let's say A10 which will give the SUM of A2-A? where ? is a number specified in cell C1. So if I put in a 4 in C1, cell A10 would read 22. If I put in a 6 in cell C1, cell A10 would read 31. Can anyone help me here? Thanks! One way Put in A10: =SUM(INDIRECT("A2:A"&C1)) -- Rgds Max xl 97 --- GMT+8, 1� 22' N 103� 45' E xdemechanik <at>yahoo&l...

I'm trying to enter a formula so that when I type numbers in columns, like B & C, I get the result (of multiplying) the columns in column D or wherever. I can do it individually, but for the life of me I can't figure out how to make it apply to all the numbers as I add them. Help would be outstanding!! TKS Hi TKS I am not quite sure if I understand you correctly, but what I would do is this: If you want to have numbers in Columns A, B and C and multiply them in Column D, you could enter following formula to your column D: =3DA1*B1*C1 which of course only works, if all three...

I had used an "IF " formula ( in cell C3) and get the result in cell F58. Cell F58 is a blank cell with photo. I need to screen to show cell F58 that is move the cursor to cell F58. What is the command to be put in the "IF" formula? Thank You ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then clic...

I have some long formulas that cause the formula bar to display over the column letters. It helps when I check formulas to see what columns are in the formula without having to moving back and forth to a blank cell. Is there a way to move the formula bar so I can see the column letters? Thanks, Phillycheese5 -- Phillycheese5 ------------------------------------------------------------------------ Phillycheese5's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24196 View this thread: http://www.excelforum.com/showthread.php?threadid=498800 You can toggle it off...

I've to create a chart using a formula instead of value. Is it possible ? Do you mean something like have values a A1:A20 and formulas such as =2*A1^2+3*A1-7 in column B? If so just select the cells and plot. If you want a more complex answer I am sure one of the MVP will provide it shortly. Bernard "BoB Bedford" <NoSpam@YouKnowWhatToDoHere.com> wrote in message news:%233l5DyX8DHA.2712@tk2msftngp13.phx.gbl... > I've to create a chart using a formula instead of value. Is it possible ? > > Hi Bernard, Thanks for your help > Do you mean something like ...

I have a plethora of spreadsheets that I would like to alter by adding specific text to all cells immediately to the right of a cell with specific text. Example: For all cells that read University of Maine I would like to add a cell to its right that has the text "Black Bears Main Gym". How do I get excel to do this for me without me going through, finding all desired cells and adding the new info myself? Please help ASAP. Much appreciated! Edit/Replace HTH, Greg "CJer" <anonymous@discussions.microsoft.com> wrote in message news:199d201c41cd1$9cf91a50$...

I have set up a spreadsheet showing charges & payments - s far I have four pages. How does one set up the total at the bottom of page 1 to be carried forward to the next Pages ? When you say "pages", do you mean worksheets? If so, then you can just reference the cell on Sheet 1 from Sheet 2. Like this: In a cell on Sheet 2 enter: ='Sheet 1'!A10 This will pull the value from Cell A10 on the worksheet called Sheet 1. Change the worksheet name and cell reference to match your own. HTH, Elkar "Ricsec" wrote: > I have set up a spreadsheet showing ch...

When I drag the formula in a cell it appears correctly in every copied cell but returns the numerical value in the original cell. "hanslip" <hanslip@discussions.microsoft.com> a �crit dans le message de news: 7DCE8264-5AA3-4AC7-9A82-D19C36C24E54@microsoft.com... > When I drag the formula in a cell it appears correctly in every copied > cell > but returns the numerical value in the original cell. Click on Office button, Excel options, Formulas, Calculation mode, and check that "automatic is selected. Daniel These are the 'Help' instructikons that ...

Hi I am very used to making macros with Lotus123 ... yes, the oldie one. But now i am lost with Excel. Lets say i am in a column F for ex. The number of lines is not constant. I want to copy the formula in F9 to cells frim F10 to the end of the ciolumn. In Lotus i would go to the {end}{bottom} How do i do in Excel ? I am really lost with this VB language. Help is very welcome. Michel "Michel" <.@.> wrote... >I am very used to making macros with Lotus123 ... yes, the oldie one. >But now i am lost with Excel. > >Lets say i am in a column F for ex. >The number o...

I get the opposite effect when I apply this formula... =IF(D75=D76,"Balanced","Error") The answer is "Error", even though the amount is exactly the same in D75 and D76. If I reverse it I still get the wrong answer... =IF(D75<>D76,"Error","Balanced" The answer is "Balanced" I must be missing some very basic syntax knowledge. The cells D75 and E76 are definitely the same number format. Thanks for your help. Not sure, it works for me. But as your last paragraph mentions D75 and E76, should the formula not be: =IF(D75...

What formula do I apply to the following Start time is 10:00 PM and finish time is 7:00 AM Answer is 9 hour shift I need the 9 hour shift to read as 9:00 or simply just 9 I have been trying out the TEXT function but my answer is 15?? Thank you for your replies. Try =MOD(endtime-start_time,1) or perhaps more pedagogical =(endtime<start_time)+(endtime-start_time) start in A1 end in B1 =MOD(B1-A1,1) or =(B1<A1)+(B1-A1) -- Regards, Peo Sjoblom "SpiderKat" <anonymous@discussions.microsoft.com> wrote in message news:6231A72E-986B-495B-8CF7-66815F5AAC8F@microsoft.co...

I have an array constant {1000,1.2,2%} in cell A1 S = 1000 P = 1.2 R = 2% How do I reference the array constant to create this formula: =(S/P)-((S/P)*R) Hi, I can't duplicate your entry. First, to be an array it must be entered starting with an = for example ={1,2,3} Second, you show the last argument as 2% - Excel won't accept the % in and array entry. Maybe you are typing {1000,1.2,2%} into the cell? If so, it is not an array, its just a bunch of text. You could enter it as ={1000,1.2,0.02} -- Thanks, Shane Devenshire "notso" wrote: > I have an array co...

I am building a spreadsheet that will continue to grow in size. Th basic outline of the spreadsheet is as follows: A // B // C // D // E // F // G // H // I // J // K // Sys Name // Project // Type of Bldg // Type of Work // Type of Price / W/L // LNFT // CST // HRS // $/LNFT // HRs/LNFT // Consept of the sheet is: Column A will be grouped (using the Group command) Column B is input for reference only, no lookup functions need apply Column C is a Drop Down menu consisting of approximately 10 differen types of Bldg. Column D is a Drop Down menu consisting of approximately 5 differen types ...

How would I make an if formula to say if Column A = MF then add the numbers in column B so that it would be MF=18 and FW=8? A B MF 3 FW 4 MF 2 MF 6 MF 7 FW 4 One way: =SUMIF(A:A,"MF", B:B) In article <0a4601c37b9f$56f0bd20$a401280a@phx.gbl>, "Matt" <matthew_elliott75@yahoo.com> wrote: > How would I make an if formula to say if Column A = MF > then add the numbers in column B so that it would be MF=18 > and FW=8? > > A B > MF 3 > FW 4 > MF 2 > MF 6 > MF 7 > FW 4 ...

I have a table of data based upon the 12 months of the year, one month per column. Other data is added to the spreadsheet with associated month numbers: e.g., 124 for 1 (January), 34.5 for 4 (April), etc. This other data comes in sequentially; i.e., if there are only 3 months of data, they will come in three adjacent cells. I need to ensure this other data is placed in the correcy month within the table; e.g., 124 for 1 is put into the table's January column; 34.5 for 4 is put into the table's April column; etc. I seem to remember, a while back, there was a function(?...

I update, track and save about 80 workbooks. They all have the same format and formulas. However, occasionally I need to change the formulas, so I have to update every workbook. Is there a way to save the formulas on one workbook and have all the others refer to the formulas on this. If so, how should I do this? Josh, If you want to actually change the text of the formulas, no. If you want to get data (stuff a formula returns, or text or numbers in a cell), use a link. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- &quo...

Hello first of I will explain what i need. i work for a printing company and we need something that will calculate direct costs and overheads i have created a workbook that contains the following: sheet1 contains a list of 26 stocked papers, cost per/000 and cost per sheet. sheet 2 contains labour costs for: binding, laminating, and printing. for each their is cost per hour, surplus materials, and cost per unit. Also for each of the processes their are 2-3 variations. for example for laminating it can be: gloss, matt or un-laminated. Each costing a different amount. Now this is where I...

Hi I am after a formula to clauclate working days for office 2003 not 2007? For example if the date which i have in cell B2: what code/formula would I use to determine one working day from that date for cell C2? Hope that makes sense, basically I want to clauclate 1 working day from the date entered in a cell. Mnay thanks Check your other post. housinglad wrote: > > Hi > > I am after a formula to clauclate working days for office 2003 not 2007? > > For example if the date which i have in cell B2: what code/formula would I > use to deter...

Hi please post your question as body of your message. Guessing you probably want something like: http://www.mcgimpsey.com/excel/timestamp.html -- Regards Frank Kabel Frankfurt, Germany "Tucson Guy" <TucsonGuy@discussions.microsoft.com> schrieb im Newsbeitrag news:0488EA8C-8BA7-4816-AEF9-C62166FB926D@microsoft.com... > ...

So on one tab I have my colleagues enter certain values for that day and on another tab (a month overview and a year overview) it automatically copies the values over and then uses them in formulas to calculate data for graphs. I can get the data to copy over if the days match, and for it to remain blank if not. But how can I automatically set it up that once the day has been, it saves the information it had copied over previously rather than going blank because the dates no longer match? (Hence altering formulas and graphs?) Thanks in advance. ...

This is a multi-part message in MIME format. ------=_NextPart_000_0139_01C4B566.BB700970 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi- Would someone tell me how to include a custom image that I used in a = report in chunk file? Thanks- --=20 Roxy ------=_NextPart_000_0139_01C4B566.BB700970 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type cont...

I need help in creating a purchase order form for supplies to be ordered from a catalog.... It should say: Page # Description Item # Color Quantity Price Total Is there such a template and if not how can I create it? Have you searched online and at MS template site? http://office.microsoft.com/en-us/templates/default.aspx Regards, Peo Sjoblom "Angela" wrote: > I need help in creating a purchase order form for supplies to be ordered from > a catalog.... > > It should say: > > Page # Description Item # Color...

As Subject, Is there any migration tools or step for Goldmine migrate to CRM verions 1.0 or 1.2. Is there any beta or trail version available for download? Both 1.2 and 1.0 have this tool. Follow the instruction to export your GoldMine data to CDF database, then run migration tool to import cdf data into your new installed CRM system. I did it myself. It really works. You can find the document and tools from microsoft's website. >-----Original Message----- >As Subject, > >Is there any migration tools or step for Goldmine migrate >to CRM verions 1.0 or 1.2. > &...

Hi! We deployed Exchnage 2003 (back-end and front-end) on W2K3 AD. If our users on the Exchange organozation create mail forwarding to the external mail accounts, the return-path in header is missing. For example: Tom has an Exchange mailbox with the alias tom@aaa.com. Tom created a forwarding rule in Outlook 2003 to sue@bbb.com. An other not-exchange user with the alias timy@ccc.com send an e-mail to Tom. Sue had the forwarded mai in her mailbox. But Sue cannot find the header information from which person she become the mail. There is only information in header that Sue received this...

Hi there, my problem is, that i need something like: there is a function in a excel-cell (for example '=setvalue("sqlserver", "DB", "table")'). now i type in a value (for example 100) then the function "setvalue" must write this value (100) in the server, db and table from the parameters. after leaving the cell the formula is still the same and only the value 100 ist visible for the user. and if i go back to the cell than i can see the function in the menubar. there is a product from applix (TM1) and they did it. the problem is, that the souce...