0.3106552 Does This Look Good? ... 0.5603709 0.5883698 Now Visit Tobacco Is Drugs 0.7272271

i have to find out how many years employee has been working on the job. using current date - hire date/365. result have to be in years? who knows the right...

I need to count the number of nonblank rows that have a certain criteria in a different column. I assume that some version of the SUMPRODUCT formula will do...

I've looked around for this issue and can't seem to find one - my apologies for any duplications. At the top of Column B, I have a total amount. I have a...

A2 contain the following string : ** CLAIMS ** YR2006 NO. 1 INC $959.82: YR2007 NO. 2 INC $30,708.72: YR2008 NO. 2 INC $13,922.14 I want in B2 to add up...

Using both Excel 2003 and Excel 2007, I calculated the net present value of the stream of payments shown below four different ways: 1) Using the XNPV...

Read all these posts but none seems to address this. I've got a file "A" that has an input table and an outputs table. I change the input values, which...

How do i click and drag a formula while keeping one of the values constant? ie: A1*C1 A1*C2 A1*C3 etc,

When I try to link an excel 2007 cell to a 2003 cell, it does not allow me to link them. When I click on a cell and enter an = then I used to be able to...

Hi, is there any solution to extract the text written in a comment box to a specific cell I tried the following but this message “#name?� appeared ...

I would like to create multiple tables of figures by grouping them by subject. I went through the training on how to create muiltiple TOCs but that doesn't...

I want to have tab named for a specific category, then have multiple subtab worksheets for specific jobs In that Category.

I'm trying to count the number of "late" occurrences by a persons name that fall within a 90 , 90, 60, 30 wondow. So there's 2 conditions, the persons...

I have a workbook with 12 worksheets titled the 12 months of the year and a worksheet creating a report titled "D&O" (District & Office Report). I need to...

Hi, I am having two strings with different first characters. One looks looks like a pair of "L"s and the other a solid vertical block. Both these characters...

I'm hoping someone can help with this problem I have a workbook created in excel 2000 with macros in it and also a custom toolbar. When I open the workbook...

I am attempting to write a COUNTIF statement with greater than and less than functionality. I have 2 worksheets. Sheet 1 contains the extracted data from...

=TEXT(DATE(2009,4,1),"mmmm") doesn't work for different locales. This one is done for english based locale, but will not work for russian because format is...

Is there a function or formula that can calculate which numbers add up to another. for example: 5 6 7 8 I want the combination of numbers that will give me...

Hi, I need to find out if I am within the time specified.. ColA has start time and ColB has end time.. Col A Col B 17:30 04:30 18:00 05:00 16:30...