Automatically Insert Number of Days in Specific Month

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

Excel Formulas Question:

I want to know whether it is possible to set up a formula that would automatically insert the number of days in the current, previous month or specific month. Currently I am having to manually insert t..... Read The Solution..

IF Statement Calculating Average Has Numeric and Text

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

Excel Formulas Question:

What is the best way to create an equation that will calculate the average if the responses or options can either be a percentage (number) or Yes-No response its really important because i have a works..... Read The Solution..

Writing a Formula Which Dynamically Generates Results

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

Excel Formulas Question:

Id like to know whether it is possible to write a dynamic formula based on different kind of data present in a particular column and generates results dynamically which is depending on the data being a..... Read The Solution..

« Previous Page