Home Tags Formula
I am trying to come up with a formula where if the sum comes to 0 in the next cell I want it to show Low, but if it comes to 1 then it should show Med or 2 or higher then it should show High....we chose to us the IF statement and combined it with conditional formatting to solve this request.
For this problem we received a copy of the workbook. We then used a formula to count the number of 'Product' occurences for each staff member. That count was then transferred to a staff member summary worksheet to report the total counts for all 'Products' across the team. To simplify the formula and the structure of the workbook we also recommended to record all the staff time into one worksheet for the year, rather then a separate worksheet for each month
For this problem we received a copy of the workbook. We then used a formula to extract the last two digits of the text string. From there we sorted the worksheet by the extracted digits to acheive the result. See the post for screen shots of the un-sorted list, the formula used and then sorted list.
A reference to another sheet always includes the sheet name (Sheet1), an exclamation (!), and the cell reference (I6). In this case we want the sheet name to be a reference from another cell in the worksheet and that whole reference to then be calculated. In each case the end of the reference is to the same cell "$I$6" which is the location of the Password in each worksheet. Then in front of that reference we want to insert the worksheet name. We need to get a combined string with the worksheet name and the cell reference, to acheive this we can use concatenation.
Annualized Standard Deviation - I have quarterly performance returns for a portfolio and I believe I got the annual standard deviation for 2006, 2007, 2008, 2009, and 2010 using Excel. The next thing I need to do is get an 5 Year Annualized Standard deviation number and I have no idea how to do it. Any help would be appreciated.
12Page 1 of 2