Functions

ratio using DATEDIF function
Morning everyone I am trying to put 2 formulas into one cell but seem to be struggling, I am sure this is simple and could really do with some help A1 = 4 B1 = 12/02/2007 C1 = 08/03/2010 In D1 I am doing the following forumla (I am trying to get a result of 4:36) =A1&":" + DATEDIF(B1,C1,"M") I keep ... 8 Mar 2010 06:25

Merging Columns
Hi was trying to merge two colums in to one, and both columns have about 500 client lists. In column A I have first name and in Column B I had Clients last name. But I wanted to do both in on columns. So instead of doing one at a time I created the following formula in C 1 >>> =CONCATENATE(Sheet1!$A:$A&" "&Sheet... 8 Mar 2010 04:15

Percentage Help
Hi All, I am trying to figure out how to get a percentage to show up in certain cells. THis is what I have: C D E F G List Price Retail Price Wholesale Sponsor1 Sponsor2 20.00 49.95 =8%*D2 ... 8 Mar 2010 03:11

Missing alphanumeric number in the sequence
hi, please help me here. i just would like to know, is there a formula to detect a missing alphanumeric number in a sequence? Ex. if i have AA01, AA02, AA03.......AA100. how to detect of example AA03 is missing? please help...thanks! ... 8 Mar 2010 05:20

Data to another sheet
I have a table for marks of students. I have their ranking in the last col. In the next sheet I have another table in which I want the names of the first three to come. Is there any method? ... 8 Mar 2010 01:03

vlookup 3 sheets
Hi, I have 3 worksheets and want to combine a vlookup to find the sum of the unique criteria. I can get it to work with 2 spreadsheets but not 3. The formula i am using is: =IF(ISERROR(VLOOKUP($A99,'sheet1 v4'!$A$3:$AR$103,COLUMN(AR99),FALSE)),VLOOKUP($A99,'Sheet2 v4'!$A$3:$AR$98,COLUMN(AR99),FALSE),VLOOK... 7 Mar 2010 22:53

#DIV/O!
I get this #DIV/O! when I divide two cell that both total 0. These cell will not always be used in the spreadsheet. Is there any way to show the total of these cell to be 0 when not used? -- Joe ... 7 Mar 2010 23:58

Future date with six day week including holidays
can anyone help me with this a. how to get future date (like WORKDAY Function) but the formula should include saturdays as work day excluding sundays and holidays. for example if 2 mar 10 is the starting date then plus 15 days including 2 holidays (say 5 mar 10 & 9 mar 10) and sundays (i.e. 7 mar & 14 mar) the to ... 9 Mar 2010 05:39

Please help
I am really sorry I have left msg here a week ago but I can not find it now. I found out what I need to do. Here is example A B C D 1 222 333 343 OK if I put 1 in A1 it is going to show above for columns B, C, and D If I put 2 in A different numbers will sh... 7 Mar 2010 23:58

Vacation Tracking formula
I am trying get my formula for hours accured in a vacation tracker spreadsheet to show up as 60 minutes in an hour instead of 100 minutes. =(D8/(52/$J$12)*D10 results are 1.85 hours, I want it to read 2.25 hours Cell D8 = 48 hours Cell $J$12 = 1 weeks per pay period Cell D10 = 1 accured every # of periods ... 7 Mar 2010 23:58