Archive

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?

Read more

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.

Read more

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?

Read more

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....

Read more

I'm a music lover and I want to stream audio from my Android to my Mac.  Is there a way to do so? The AUX port on my smartphone is no out of order so I can't transfer music using wire. I'm currently using OS X 10.9.1 and Android 4.4.2. Any suggestions?

Read more

I'm getting a lot of notifications on Android these days because I have installed a lot of applications on my device. My smartphone runs on Android 4.4 Kitkat. How can I turn off the notifications in Android 4.4 Kitkat? Will the RAM get freed if notifications don't come time and again?

Read more

I have MacBook Pro and it is working fine. It doesn't lag, it runs all applications but the appstore on the book doesn't download any updates. I have updated to Yosemite two days ago and I'm facing this problem from the past 48 hours. Is there a way to fix this problem without downgrading my OS?

Read more

I really don't know what's actually going on. Two member, brother and mother, from my family have updated their iOS and they receive the message which I must be receiving. I don't know if this is an update issue but this all happened after the updates last week. How can I fix this?

Read more

I want to install Microsoft SQL 2008 Server but I fail each time when I try. I currently use 2005 Server but I would like to upgrade to 2008. The installation continues till the last step and I end up with a error, 'One or more devices connected to the system has malfunctioned...' How can I fix this error?

Read more

Google and Yahoo are the best search engines. They show a lot of results and solutions to any kind of search or problem. Google has many software like the Android, Input Tools, etc. while Yahoo streams live concerts. Which is the best among Google and Yahoo? Which the mostly used search engine among all?

Read more