Switch Minutes to Seconds in Excel

October 11, 2009 by vba excel · Leave a Comment
Filed under: Excel Formulas 

Excel Formulas Switch Minutes to Seconds in Excel [Q]

I have a telephone-report that gives me the number of seconds each
conversation has taken. I want to convert these seconds in a hh:mm:ss format. Is there a function o..... Read The Solution..

Excel Sumif Multiple Criteria

October 4, 2009 by vba excel · 2 Comments
Filed under: Excel Formulas 

Excel Formulas Excel Sumif Multiple Criteria [Q]

I need help on microsoft excel sumif multiple criteria, Given range named “type” and “qty”, i am trying to write a formula that will sum..... Read The Solution..

Calculate Age from Two Date Cells

April 5, 2009 by vba excel · 2 Comments
Filed under: Excel Formulas 

Excel Formulas Calculate Age from Two Date Cells [Q]

Ive a problem related to microsoft excel formulas, I need to find if a person was 40 years of age or older (= or >) at his Date of Hire. I have two columns or cells in ex..... Read The Solution..

Look to Cell References to a Worksheet

March 26, 2009 by vba excel · Leave a Comment
Filed under: Excel Formulas, Excel Worksheet 

Excel Formulas Look to Cell References to a Worksheet [Q]

I have a microsoft excel formula in Sheet3 in cell A1 that is something like this:

=Sheet1!A1

This excel formula of course is looking to Sheet1 for the co..... Read The Solution..

Using Percentile with Specific Cell in Worksheet

March 25, 2009 by vba excel · Leave a Comment
Filed under: Excel Formulas, Excel Worksheet 

Excel Formulas : Using Percentile with Specific Cell in Worksheet [Q]

I am trying to use microsoft excel percentile formulas with specific cells in a column. Further example:
A
1 5
2 6
3 7
4 8Read The Solution..

Next Page »