Functions
in [Excel]
|
How do I calculate a weighted average and exclude the empthy cells I am looking to complete my formula for calculated weighted averages. Here is what I have: A B C D 1 weight 20% 30% 50% Avg results 2 results 1 100% 100% 90% 95% 3 results 2 100% 90% 47% The formula I have thus far is for D... 27 May 2010 23:38
sales tax chart I know there must be a formula to figure this out easily, but I can't do it. I am trying to make a chart like the illustration without figuring every line. {$9.50-$10.05=$.96(tax).} I have the formulas worked out to $100, but I am needing to eliminate the exta lines one by one to create the x-x part. Isn... 27 May 2010 20:23
averageif with 3 crieteria SUMPRODUCT(--(S498:S534="a"),--(G498:G534>=100),--(G498:G534<=200))/SUMPRODUCT(--(S498:S534="a"),--(G498:G534<>"")) I searched questions already answered but did not see averageif with 3 criteria I want the formula to return the average. Thanks in advance ... 28 May 2010 20:23
Convert Week number into Month I have a worksheet with values for year and week number. I need to convert these to the descriptive month name. Some weeks cross month ends, but this is okay, I just need a single value for each record. It could be the month of the first day of each week number. Using Excel 2003. Thanks for your ideas. ... 28 May 2010 13:46
Convert Week number to Month I have a worksheet with year and week number and want to use a funtion to convert these two values into the descriptive month. Some weeks cross months, but that's okay, I just need one value returned per record. It could be the month that the first day of each week falls in. I'm using Excel 2003. Thanks! ... 27 May 2010 20:23
How do I preserve font/size when sending text to a different cell I am making a template for a restaurant menu and have the complete menu listed on the page. The menu I am creating is on the same page and would allow me to select only items a customer may want on a "personalized menu". So, I have set up formulas to insert the items I check off on the complete menu to be aut... 27 May 2010 21:29
Return values that sum to a known value I have a list of data and would like to know if there is a formula that would return any items from that list that sum to a known value. ... 28 May 2010 07:10
Search, Match, Pull Hello, I am looking for help to: Search through two columns (one for employee, the other for employee number). I want it to match those two criteria and than pull a specific feild (say hours) to another organized page where I can than make charts. Does anyone know of a formula that can do that for each ... 27 May 2010 20:23
Address must be 18 characters long Hi all again I need the address to be 18 characters long i.e. if the address is over 18 characters then chop it, if its under, then add spaces Is this possible? Thanks as always Derek ... 1 Jun 2010 08:39 |