| Thread | Last Post | Replies |
|
| I Need HELP with "IF" "THEN" I think???? | 23 Jun 2007 16:21 GMT | 9 |
I hope some one can help me... I'm been trying to get this to work for 5 days now!!! HELP!!!! LOL I need a formula that I copy and paste into a cell down a spread sheet Not using a macro or pivot table. I dont know how to set them up.
|
| Line Reference in Formula | 23 Jun 2007 14:31 GMT | 3 |
Is it possible to include a number in a cell as line reference in a formula? Example: Cell A1 = 45; Formula in C5: = (any column, say) L45
 Signature Felix
|
| excel menu bar missing | 23 Jun 2007 14:21 GMT | 1 |
The main menu bar containing "File Edit Tools etc" is missing How do I get it back. I have reloaded excel with no results Trevor
|
| Excel libs/Runtime for .NET | 23 Jun 2007 12:51 GMT | 1 |
I would like to develop .NET app that references Excal 2003 libs on machine which does not have Excel 2003 installed. Where can I get these libs? Maybe somehwrw exist Excel runtime or so? Thanx a lot.
|
| When using show pages in a pivot table can I keep the page setup? | 23 Jun 2007 12:48 GMT | 1 |
I have set up a pivot table and want to use the show pages option however the actual page setup is not preserved when you do this - i.e. I have set up the first page to print as landscape but the subsequent split out of the table puts everything as portrait - is there any way the ...
|
| Labor Costs Budget to Actual | 23 Jun 2007 12:42 GMT | 1 |
I'm looking for the best way to compare actual labor costs that I have in an excel file to another excel budget file. In my "Actual" file - there are multiple rows for each employee b/c of labor distribution. I have been using Vlookup to do the comparisons but am wondering if ...
|
| excell formula can any one help | 23 Jun 2007 12:31 GMT | 3 |
Take an example of d7 is 25 kg now in cell g 7 I create the formula =f7/40 this returns 0.625 how do I get this to round up to and show 1.00 in cell f7 Hope you can help
|
| Copying an Excel sheet keeping the formulas in the copy linked to | 23 Jun 2007 11:24 GMT | 1 |
I have created an Excel sheet and need to create a copy in the same Work Book. This copy needs to be linked to the original with regards to formula. The purpose is that when any changes are made to the original it should be made automatically to the copy. Pls advise how can I do ...
|
| how do i find exact values in other excel file | 23 Jun 2007 11:06 GMT | 2 |
i need to refer to files when i am doing this particular task. the first file give me details Item, Description, Balance Quantity, Quantity Order,Quantity to be ordered. and the second file contains the write off item codes ie these items will
|
| REport cards and standards (state) | 23 Jun 2007 10:46 GMT | 1 |
Hi. I am trying to develop a report card using excel where the subject is listed (ie-Reading) and then individual standards and whether a student has mastered them, etc for the 4 grading period and then an overall final grade. Any suggestions on how to do this? It is getting ...
|
| Formula, Conditional Formula Needed | 23 Jun 2007 04:12 GMT | 12 |
I have a spreadsheet where I have a value in cell n7,n19 and n31 I want to have the cell of those 3 with the lowest number between them to turn green and the other cells stay as they are. Thanks Karl
|
| If function question in conditional formula | 23 Jun 2007 03:59 GMT | 2 |
I need help with creating a formula that will find a name in colums A & B, if true or false a % is returned when comparing a value in another column. The following formula only works when the name is found in both columns A&B. I need to check if the name is found in either column ...
|
| Excel 2003: spreadsheet / workbook extends to far to right. | 23 Jun 2007 03:02 GMT | 1 |
I have a spreadsheet that starts at A1 and ends at AK. (on horizontal plane) However when I scroll to the right the excel window goes to CB (way past AK) How can I reduce this so as the workbook ends at AK Hope I explained this ok am a bit short on window termanology.
|
| I copy a formula and the results copy from the original cell | 23 Jun 2007 01:35 GMT | 1 |
I created a simple formula in a cell (D4+E4) and the result is, for example, 100. When I copy the formula into the line below the formula changes to (D5+E5), however, the result from the original formula, 100, copies into the cell instead of the result for the new row, say 74. I ...
|
| Multiple instances | 23 Jun 2007 01:13 GMT | 2 |
I have a user at work who is having a problem when he opens certain excel workbooks, that contains multiple worksheets. Several (3 or 4) instances of this workbook open automatically, each with a diffirent sheet open. Has anyone seen this and know what the fix is?
|