Hi, I went to  at this instant Doubt there is a formula in excel. Let's day I equally hired Feb 24, 2014 so regularization is 6 months, so my regularization date would be August 24, 2014. I went just before at this instant the formulary in excel so I can craft an automatic record. Equally, big name answers me.

Hello! I need to know some important formulas which can be used in MS Excel when something related to statistics is implemented. What combination of keys (formula) can be used to find

1) The mean of a range of cells?

2) The median of a range of cells?

3) The standard deviation of a range of cells?

4) The mode of a range of cells?

5) The sum of a range of cells?

6) Display the largest value among the range of the cells?

7) Display the smallest value among the range of the cells?

I have been trying out a formula on Excel and I cannot seem to get the required result. I have worked out in a different place twice and I get a different answer to the one I get on excel. Here is the formula:

For A1 4900 and A2 4900,
=(A1*2+A2)/450+IF(A1>4800,6,IF(A1>2400,4,IF(A1>0,2,0+(IF(A2>4800,6,IF(A2>2400,4,IF(A2> 0,2,0)))))))

I believe the answer should be 44.6667 but I get 38.6667 using this formula. Can I get the formula to work as desired?

I have created a form in Excel and labeled it ‘Form 1’. This form is to act as a command button, in that whenever it is clicked, it leads to a different spreadsheet. The data in form 1 is placed in a combo box, hence it varies according to what a user picks. I need a code that would enable the command button choose a spreadsheet to open when a value is chosen. Any help?

I have come across a site with financials and I want to enter them in an excel spreadsheet. The problem is that the site is password protected and I need assistance to copy the data with macro transfer from the data sheet to the template sheet. I believe a named range would be the best approach and I have researched on the same with no success. Help me in naming the financials that would be used in the template. I will also need help in recording a macro that can run for every new company analyzed. Help me on this

I was working on some data in an xls sheet just the other night and I happened to cut out some data but the lights went off before I could paste it where I wanted. The problem is that I had hit the save button on the spreadsheet. How can I recover these files? Is there a software that I could use or is there a place that I should search on the computer in order to get a previous copy of the xls file?

I didn't get the right category for this question so I asked the question in MS category. Sorry for the inconvenience.

Now onto the question,

I don't use MS Office. I only prefer Open Office. How can I lock a row of cells in Open Office Calc? I'm not able to locate the right tab for this function.

Is it possible to create a customized taint for colors in excel that I can use for my presentations? How would I get to do this? I want to able to change the default taints that exist and be able to make some of my own so as to make unique presentations