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..

Conditional Formula in Different Worksheets

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

Excel Formulas Question:

I have two excel worksheets
Excel Worksheet 1 has the primary input
Column A1: M Column B1: $12.5
Column B1: S Column B2: $17.00

While Excel Worksheet 2 has a value of M or S i..... Read The Solution..

Intersection of Two Tabs in Excel Worksheet

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

Excel Formulas Question:

I need your help regarding excel formulas problem, i have sampled some data in excel and come up with a sample of 155 data number then I want to copy the sample into another tab in worksheet from a sa..... Read The Solution..

Next Page »