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 an XP drive with outlook. Now I need to copy the PST file but I do not know how to find all the account settings. It is an NTLBusiness email and I have researched everywhere on the web without a solution. Anybody with an idea please help me out.

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 have made a word(.doc) file in MS Word and it is not encrypted or corrupted. Other office suites like WPS and Corel open the file but Open Office doesn't. 'This is not a WinWord97 file' is the error generated by Open Office. What is the reason behind this error?How can I fix it?

MS Outlook is very popular. It is available in the PC and in Android. What are the features in MS Outlook for Android? Softonic has rated it the app of the week. What are the things to look forward in MS Outlook Android version? Is there a good alternative to MS Outlook?

Is there a way to convert .doc into .ppt in MS Office? I want Power Point to show the contents of my .doc file one by one visible as an animation. If this feature isn't available currently then what are the things to be done in order to make it possible?

I am using outlook and it gives me an error and then closes outlook. I believe there might be a problem with the files but I do not know how to go about it. If my files are infected by a virus or are corrupted, is there a friendly OST recovery solution that will scan these files and repair them? I need them to open in any form and if they will occur as PST on the downtime/offline exchange server, it will be okay.

I have been trying to save my data, currently in Lotus notes to Microsoft outlook. Is there a way that I can implement in order to save these notes without any losses? The data is very important and I do not want to lose any of it, therefore, please help me find the best solution.

I have Microsoft Office 2013 and whenever I use PowerPoint, it keeps telling me that it is attempting to repair some files that I do not think they have a problem. Even the other day, I copied a file that was working well on my friend’s laptop and when I tried opening it with mine, PowerPoint kept trying to repair it for like 20 mins and eventually failed to open it. What could be the cause of this problem? Is there an easy way that I could implement to repair it? Please advise me how to go about it.