Group:  Microsoft Excel » microsoft.public.excel.worksheet.functions

Geek News

Threads Replies Last Post
1263 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>  
Funtions return wrong result BUG in Execel ???
IF funtion and or funtion returningen wrong result when using decimal numbers. Exampel: a1= 300 b1=303,6 c1=b1-a1 d1=3,6 e1=if(c1<=d1;"ok";"not ok") this one returns "not ok" which is wrong result !!?? a1=300 b1=303,5 c1=b1-a1 d1=3,5 e1=if(c1<=d1;"ok";"not ok") this one returns "ok" which is right result. Be aware that c1 and d1 is equal in both exampels, only the...
9 12/28/2008 2:26:27 PM
Mirror formating changes in seperate worksheet
I'm not sure if there is a function for this, but I have two worksheets that will having the same core structure (same column headings and rowing headings, but different data). I want to know if there is a way that if I add a row in the second worksheet. Any help? ...
2 12/28/2008 9:40:02 AM
value shows in words
Ihave an excel sheet. and there is a column called A1= "Value" there I will put the amount of an employee.... the next column called " Amount in words" I need to get the value in words which I am putting on the "Value" column.. How can I get that problem solved. Regards- Mujeeb. ...
3 12/28/2008 9:35:20 AM
Help with time interval
Hi Team, I work in a call centre and trying to write a formula which allow me to classify calls received / abandoned between 30 minute intervals . Time abandoned No of calls Time 9:00:00 am 1 This is where I need the formula (output should say 9:00-9:30 am 9:08:00 am 1 output should say 9:00-9:30 am 9:10:00 am 1 ...
8 12/27/2008 9:35:11 PM
Need help with formula
This may have gotten posted twice and I apologize if it did. I have racked my brain to try and figure this out. I have a worksheet with the following I am having trouble with the ROUNDDOWN part of formula in Columna J. Col E: Monthly Pmt Col G: Total to be paid back Col H: Amt Pd so far =IF(TODAY()<=R30,MIN(G30,E30*J30),MIN(G30,E30*J30)) Col I: Balance =IF(H...
2 12/27/2008 8:10:14 PM
Advanced Filter using a range name as the criteria
I am running a macro and want to select records from a database that are within a date range that the macro prompts for. So macro gets STARTDATE and ENDDATE and has stored them in a date formatted field. STARTDATE=1/3/2008 and ENDATE=1/5/2008 The database is Event Date Event Name 1/1/2008 Event 1 1/3/2008 Event 2 1/5/2008 Event 3 1/7/2008 Event 4 What is t...
2 12/27/2008 6:23:10 PM
Work Calendar
I am a fire fighter and i only work every other day. is there a way to get excel to color the dates that i work automaticly?...
3 12/27/2008 6:15:39 PM
wrong result if function values over 256
very strange behavior of if function resulting in wrong result which might be a bug. try it out at your own, and try other values just remember the same difference. a1=300 b1=303,6 c1=b1-a1 d1=3,6 e1=if(c1<=d1;"OK";"NOT OK") the result of e1 should be "OK" but its "NOT OK" a1=200 b1=203,6 c1=b1-a1 d1=3,6 e1=if(c1<=d1;"OK;"NOT OK") the result of e1 is "OK" ...
5 12/27/2008 6:10:12 PM
Subtotal withouth subtotaling
I would like to know if there is a formula that would return subtotals from a table. Let me explain. I have a payroll report with names of employees, dates of payments, deductions etc. I would not want to change the order of the table as it is updated with every week's payroll. But I'd like to generate a report from it that'd give me year to date information, per employee. Hope I'm not...
4 12/27/2008 6:01:15 PM
Dsum formula interpretation
Can someone interptert the following formula for me? =DSUM(rec_db,"9" CRITERIA!$C$1:$C$2-DSUM(exp_db,,"9",CRITERIA!$C$1:$C$2). I am not very knowledegable about formulas, I recognise the range and absolute arguments only. This formula is in a workbook I am amending. I need to understand its function to amend it....
3 12/27/2008 5:56:21 PM
Table Lookup
I have a table: Title Prod1 Prod2 Prod3 Rep $1 $2 $3 SRep $4 $5 $6 Mgr $7 $8 $9 If SRep sells Prod3 I want to be able to cross reference and return $6. The table for me to search is static. The information that will change is the salesperson's title & what product. How can I traverse this matrix other than VLookup? Thanks Much...
5 12/27/2008 5:47:01 PM
Need help with formula
I have racked my brain to try and figure this out. I have a worksheet with the following I am having trouble with the ROUNDDOWN part of formula in Columna J. Col E: Monthly Pmt Col G: Total to be paid back Col H: Amt Pd so far =IF(TODAY()<=R30,MIN(G30,E30*J30),MIN(G30,E30*J30)) Col I: Balance =IF(H30="","",G30-H30) Col J: Pmts made =IF(TODAY()<$...
3 12/27/2008 5:38:37 PM
Air Rift Air Rift man Air Rift women ( paypal payment )( )
Timberland Timberland man Timberland women ( paypal payment )( )converse converse man converse High man converse women converse High women D&G D&G man D&G women ARMANI ARMANI man ( paypal payment )( ) CHANEL CHANEL women Lacoste Lacoste man Lacoste women ( paypal payment )( )HOGAN HOGAN man Dior Dior women CK CK women EVISU EVISU man...
1 12/27/2008 7:30:13 AM
How do I test a cell's formula (ex: Is this cell and Avg or a sum?
I want to be able to test the formula for a cell to see if it is an Average or a Sum. EX: ( if the first 4 characters of the forumula for A:3 = "=AVG", then B:3 = "Average") If not, can I designate cells by color. Then test for all cells that are a certain color... EX: (if Color of A:3 is red, then B:3 equals "Average") ...
2 12/26/2008 9:54:42 PM
Need Formula for Calculating Accrued Vacation Time
Using Excel 2003. i have hire date and today(). i have a formula that calculates time employed in years, months, days. i need a formula that can help me figure out the number to vacation days accrued starting on 1/1/09. Policy: after 1 year of service = 5 days or 40 hours. after 2 years of service = 10 days or 80 hours. after 8 years of service = 15 days or 120 hours. Accrual is based on h...
3 12/26/2008 8:28:53 PM
Other users are freezing without knowing it??
Several users on a network Excel file freeze rows in the worksheet. They are not savy enough to know how to do it intentionally and the places it ends up frozen is very haphazard. Can I lock the freeze that should be maintained? And, can freeze be done any other way than the drop-down menu?...
2 12/26/2008 8:11:48 PM
Count using multiiple Criteria
I am trying to count the number of time a text srting appers. But, only if it meets two other criterias. For Example I have three columb a is rank, columb B is Gender and columb c is building. I want to count the number of times a particular rank appears in columb a but only if the gender is Male and the building is 2071. Can any one help me? By the way I need to do this in Excel 20...
10 12/26/2008 6:54:17 PM
networkdays function
I need to set the weekend days to Friday & Saturday instead of Saturday & Sunday in Excel. ...
5 12/26/2008 6:08:55 PM
How to Lock sort on a data entry sheet.
I use a worksheet “Order Entry” to enter new sales order information (a row for each order). Data is entered in columns A-F. This is a source worksheet that is linked to a destination sheet in several other workbooks used for pricing and commissions. Data is entered in the Pricing / Commission sheets in columns G-L. I want to be able to lock down or protect the Order Entry source s...
2 12/26/2008 4:34:09 PM
How to - sort a protected sheet?
I have a sheet where all the cells are linked to a source sheet. I want to allow sorting, filtering and pivot tables, but no changes / edits to the cells. I tried the “Protect” the sheet and checked the boxes to allow all users to Sort, Filter and use Pivot tables but, when I turn on the protection and try to sort I get and error “The command could not be completed by using the r...
1 12/26/2008 4:34:00 PM
Formula for Updating Several Worksheets at One Time
When I update my master worksheet, I want to save time by updating several tabs at the same time. I am using the following formula/function: =VLOOKUP("BOS",Master!A$3:B$26,2,FALSE) I have several dealers within the BOS region. I want in column A (BOS "region"), column B (dealer code), column c (dealer name), etc. The above function is pulling over the Region, but not separating the...
5 12/26/2008 3:49:00 PM
Worksheet + 1
I am working with multiple spreadsheets that contains many worksheets. These spreadsheets are a compilation of work documents, each of the worksheets are numbered sequentially. There is also a master spreadsheet to track all of the multiple spreadsheets and their worksheets. The master spreadsheet has links to each of the worksheets, but I would like to be able to do my link one time ...
2 12/26/2008 11:11:41 AM
formula required
Hi, I have a data in column A for 800 lines. Column A Column B Column C Column D Column E 123 3 123-002 123-003 123-004 432 2 432-002 432-003 As defined above, the data what I have in Column A should be counted the number of times in Column B and it has to repeated so many times in different columns with t...
9 12/26/2008 10:54:41 AM
Internships, part time jobs, and fresher jobs for students on
Upload your resume on to get part time jobs, internships, graduate jobs, volunteer work, freelance work and more. Click on the link given below or visit to upload your resume today. Past employers listed on the website include UTV, Reliance, Bharti AXA, Pankhudi Foundation, Deepalaya, Subway, and KFC
1 12/26/2008 10:16:48 AM
Excel Question
I want to past the total results of a filter command to a different column but the same row. Now I can do it but only if the row are consec. thank you and have a wonderful day and happy new year...
2 12/27/2008 11:35:47 PM
1263 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>  

Home | Search | Terms | Imprint Contact
Newsgroups Reader - provided by WiredBox.Net