complex formulas

I'm newbie to VBA and have limited knowledge in making complex formulas in spreadsheet so I'm having difficulty thinking of a better approach to achieve my desired results. I want each cell in multiple rows and columns to get a value of 1 or "" depending on the following logical test: If Name...

So I really need help with this one here. Column H needs to reflect how many points you're over or under based on several criteria. Currently, I have column F setup as follows: =IF(D8="Excellent","$99",IF(D8="Pass","$99",IF(D8="Mid","$198",""))) The ideal setup is 9 in column g, Y in columns...

I am looking for a way to write a formula that can do the following. I am doing torque values, and I created a table on one sheet that I will refer to as "torque Values" What I am trying to do is: If J9 >= 300, then take the value in O9, go to "torque values" find that value in column A...

Trying to figure out the formula for a sales rep who is over 100% of her quota. She gets Overachievement Commissions calculated as 2% of the Annual PS & Off-Site Revenue Commission opportunity forevery 1% that she exceeds her Annual Quota up to 150% of the Annual Quota. Overachievement...

I assume a Vlookup is the formula needed. I am creating a chart that is reading information from another chart. However; the new chart will be condensing the first chart into sectors. The first chart is of owned stocks and amount of initial investment per company I have listed with them in a...

I need to count the average of all dates, in a given month, that return a value. I have 10 years of data, each has a different spreadsheet, each has 2 columns that I need to deal with. 1st column is dates from Jan 1st to Dec 31st, the second column is inches of rain. I need to get an average...

<tbody> Region MSA Next PM Date Duration Frequency Frequency Key South Atlantic PA 8/9/2013 12 Every month South Atlantic NJ 4/9/2013 9 Every 9 month South GA 11/28/2012 9 Every 9 month Outsourced WA 5/24/2011 1 Every Year West CA 9/2/2013 6 Every 6 months...