Threads Replies Last Post 125 Pages: <<  12  13  14  15  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  >>   Help with formula Hi All, Running Win98SE :-( and Excel 2000. Is it possible to get assistance with the following formula. I am currently determining the Profit Margin Percent with the following ((BillRate-Payrate)-(PayRate*Fringe))/BillRate=Profit Margin % OR =((20.7-12)-(12*.24867))/20.7=27.61% I then have to play with the billrate to get a number close to 30%. Is there a way to rework the formula by plug... 10 23.07.2006 09:19:39 Unable to add color to work sheet. I have tried every sequence that I know. The painter will not paint columns, rows, cells. Any suggestions? -- davidb... 9 23.07.2006 05:09:01 Comparing info If I have a list of names (Last in one column, First in another) and fax numbers can excel compare and update or flag the numbers that changed or names who are not on the on the first list and also flag new names? Excel 2000 but could use 2003. Thanks, Linda ... 5 22.07.2006 12:01:23 excel and outlook Hi Is there a way of exporting to Outlook a list of email addresses that are listed in a column in an excel spreadsheet, with a view to batch emailing? Or do I have to cut and paste them all into the contacts section in Outlook? Or can I email to contacts from within excel? Thanks David ... 5 22.07.2006 10:59:29 compute interest at 1.05% compounded daily on $77,000 for 5 years i have invested $77,000 at an interest rate of 1.05% compounded daily. i want to create a formula showing the yield at the end of 5 years (by day).... 5 22.07.2006 04:17:57 Pull 1st 4 letters from another cell Hi Guys, I have cells with a person's name in it. Is there a function or formula to enter in the cell next to that one that will only show the first 4 letters from the original cell. Cell A1 is Amanda Cell A2 would be aman Thanks, Linda ... 4 21.07.2006 23:55:19 after selecting 50 rows of a column i can't reference the cells in the rows I have a workbook that contains energy information about every floor of a building. In column 'Z' there could be a message called 'no savings'. What i want to do is delete these rows. I have started by selecting a range within column 'z' from 10 to 175. now comes the problem. As i read through each cell how do i check the field for 'no savings' and then how do i delete the row? i have tried... 3 21.07.2006 21:29:19 A Strange Printing Problem Our accounting department maintains an Excel file, updated in an onging process, converted to a PDF at month close, and distributed to our senior management. There are nine worksheets, seven behave normally, but two worksheets default to printing 2 copies. No macros, viruses, etc. Any suggestions on a fix will be appreciated. Paul... 3 21.07.2006 20:15:01 columns Working on a spreadsheet I call "Weekly Activity Report" for employees. It has columns as follows: date-code-hours-notes If I enter a date x/x/xx, how can I set this column up to fill in the rest of the dates in for me if I have them labeled m-sun in the first column or is this even possible? m x/x/xx l sun x/x/xx... 3 21.07.2006 19:15:01 how can i print my worksheets as book i have project which consist of ten workbooks each contaning 12 worksheets. i would like to link them all togother, for seaching purposes. i would also like to print each workbook as book ie each worksheet on differrent page. can this be enbloc or will i have to print each sheet separetly cheers... 2 21.07.2006 19:05:02 How do I modify expense template to fit my needs? I need to create an expense report for a woman I occasionally work for. She has given me her files that she wants included. Each file (office, auto, etc.) includes the receipts/statements with totals. I want to be able to update and add data to it each month. She does not care how I do it nor what it looks like since she just doesn't want to deal with it at all-she just wants to look... 3 21.07.2006 18:41:02 @DSUM (123) equivalent in excel Long time 123 user converting to excel :). Trying to find equivalent function in excel. In 123 I can connect to a dbase IV (*.dbf) table using a macro. example: {DATABASE-CONNECT "dBASE_IV";;;;"c:\apfolder";;;;"table01";"table01"} END example Once this is done I can pull data from that table using @dsum (SQL)formulas in the cells. example: @DSUM(table01,"Quantity",Country=$A15#AND#Customer... 3 21.07.2006 15:56:19 The picture is too large and will be truncated The picture is too large and will be truncated This is what I get in Excel 97. I searched on the internet and only could find a MS KB article referring to Office 2000. It also appears that this is some kind of bug... that has been in the Office suite since 97 and still is in Office 2003, etc. I have VBA code copying and pasting text rows. There are no image picture involved. But when... 4 21.07.2006 15:40:05 variable range I have a variable n. I want to select a printarea using n. like (50,1:n,8) I can't see how you do that since selecting ranges only uses the "B1" type of referance for cells, not the (1,2) style. John... 3 21.07.2006 14:42:53 Exception from HRESULT: 0x800A03EC Hi The code that generates this error is the following: public void SetBuffer2(object[,] buf, int firstRow, int firstColumn, int upperBound0, int upperBound1, int wSheetIndex) { Excel.Worksheet wSheet = this.GetWorkSheet(wSheetIndex); if (wSheet!=null) { Excel.Range range = (Excel.Range)wSheet.Cells[firstRow, firstColumn]; range = range.get_Resize(upperBound0... 1 21.07.2006 11:15:29 number grab Hi I've been a bit stupid. I have about 6 columns of price data where column R is a net selling price. I've entered these column R numbers as fixed numbers. This is my mistake because I've added a formula to the P column which knocks a percentage off the R column number to give me my purchase price. What I should have done was to have the fixed numbers in the purchase price column... 6 20.07.2006 21:45:51 can I copy a column of email addresses, paste into email address? I too have a list of email addresses in one column and would like to insert all addresses into one email for a mass mailing, is it possible to do without copy and pasting each email address in one at a time?... 5 20.07.2006 21:03:01 aluminum weight formula Im a complete n00b to excel and I really need some help.... I need a formula to tell me how much certain amounts of sheet aluminum weigh. I know a square foot of 1/8" aluminum weighs 1.8lbs. Basically I want to type in the amount of square feet and get the weight. This may help to, a 60" X 144" sheet of 1/8" aluminum weighs 104.76lbs. Thanks in advance, Anthony -- sHooTer296... 9 20.07.2006 19:05:27 how i make the presantation for airtel? give me the perfect way to present ....my presentation for airtel company... 2 20.07.2006 12:04:27 Dos not work correct "Search" function Hello, I use MS Excel 2002 (10.6809.6804) SP3 and have some troubles: when I use Search function (Ctrl + F) in WorkSheet, Excel could not find same data. Randomly it may find same or not /with same conditions of search on same data/. I make example (Screenshot please look here: http://img205.imageshack.us/my.php?image=555jv4.jpg ) in my WorkSheet - I ask Excel to look position ... 3 20.07.2006 11:49:02 Creating a form to enter data I would like to be able to create a FORM on say sheet one. I would like to have about ten fields on the form I would like to then have a SUBMIT button which takes the data from the field and enters it into say sheet two. (Each column being a different field and each row being a seperate record.) Am able to do this in Access2003, but haven't used Excel for anything other than simple f... 6 20.07.2006 05:35:01 need help setting a simple format to keep rent. I'm a assistant who needs help setting up a simple format to keeping up with the rent paid from my tenants. Please help.... 3 19.07.2006 23:03:16 Text to columns When using text to columns to split a date / time formatted field which is generated bya formula I have preciously had no problems. All of a sudden the data preview pain in the wizrd now shows the formula rather than the result so I cannot split. Please help!! Thanks... 2 19.07.2006 22:31:49 How do unlock my Keyboard in Excel ... 1 19.07.2006 21:32:01 Excel to Access - formula does not work... I have the following working formula in excel and it works but when I import the excel file into Access it does not work at all. I am trying to put it in either a query or a table in Access. B C D E F MT20 120 X1542 0.2 24.00 The formula in "F" is =C2*E2 (the catagory is set to number with 2 decimals) When I enter the number into "F" it just ref... 2 19.07.2006 11:08:02 125 Pages: <<  12  13  14  15  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  >>