Windows Live Messenger, MSN, Hotmail Problems. We help you to repeair MSN, Hotmail, Windows Live...
Thursday, October 18, 2012
Logical Functions in Excel
Here are the names of the logical functions along with their argument syntax:
AND(logical1,logical2,...) tests whether the logical arguments are TRUE or FALSE. If they are all TRUE, the AND function returns TRUE to the cell. If any are FALSE, the AND function returns FALSE.
IF(logical_test,value_if_true,value_if_false) tests whether the logical_test expression is TRUE or FALSE. If TRUE, the IF function returns the value_if_true argument. If FALSE, the IF function returns the value_if_false argument.
IFERROR(value,value_if_error) tests whether the value expression is an error. IFERROR returns value_if_error if the expression is an error, or value of the expression if it is not an error.
NOT(logical) tests whether the logical argument is TRUE or FALSE. If TRUE, the NOT function returns FALSE. IF FALSE, the NOT function returns TRUE.
OR(logical1,logical2,...) tests whether the logical arguments are TRUE or FALSE. If any are TRUE, the OR function returns TRUE. If all are FALSE, the OR function returns FALSE.
FALSE() takes no argument and simply enters logical FALSE in its cell.
TRUE() takes no argument and simply enters logical TRUE in its cell.
The logical_test and logical arguments that you specify for these logical functions usually employ the comparison operators (=, <, >, <=, >=, and <>), which themselves return logical TRUE or logical FALSE values. For example, suppose that you enter the following formula in your worksheet:
=AND(B5=D10,C15>=500)
In this formula, Excel first evaluates the first logical argument to determine whether the contents in cell B5 and D10 are equal to each other. If they are, the first comparison returns TRUE. If they are not equal to each other, this comparison returns FALSE. The program then evaluates the second logical argument to determine whether the content of cell C15 is greater than or equal to 500. If it is, the second comparison returns TRUE. If it is not greater than or equal to 500, this comparison returns FALSE.
After evaluating the comparisons in the two logical arguments, the AND function compares the results: If logical argument 1 and logical argument 2 are both found to be TRUE, then the AND function returns logical TRUE to the cell. If, however, either argument is found to be FALSE, the AND function returns FALSE to the cell.
When you use the IF function, you specify what's called a logical_test argument whose outcome determines whether the value_if_true or value_if_false argument is evaluated and returned to the cell. The logical_test argument normally uses comparison operators, which return either the logical TRUE or logical FALSE value. When the argument returns TRUE, the entry or expression in the value_if_true argument is returned to the cell. When the argument returns FALSE, the entry or expression in the value_if_false argument is returned.
Consider the following formula that uses the IF function to determine whether to charge tax on an item:
=IF(E5="Yes",D5+D5*7.5%,D5)
If cell E5 contains Yes, the IF function uses the value_if_true argument that tells Excel to add the price entered in cell D5 to the same value times the tax rate of 7.5%. If, however, cell D5 is blank or contains anything other than the text Yes, then the IF function uses the value_if_false argument, which tells Excel to just return the price in cell D5 without adding any tax to it.
As you can see, the value_if_true and value_if_false arguments of the IF function can contain constants or expressions whose results are returned to the cell that holds the IF formula.
How do I make a file show I am the author in Word 2010?
Whenever you create a Word document, Microsoft Word automatically assign a author name to that document which is asked and saved in its properties at the installation time. So, if you want to change the author name in Word 2007 or 2010 then its very easy to do that.
One more thing i would like to tell you if you change the author name in Word 2007 or 2010 using this method then author name for other Office application like Excel, PowerPoint will be automatically changed, so lets see how to change author name.
Change Author Name Word 2010/2007
Change author in word 2010
STEP-1
Run Word 2010, Click on “File” tab, click on “Options” to open Word options
STEP-2
Select “General” option on the left side and change the “User name” and “Initials” under section “Personalize your copy of Microsoft Office”
Change author in word 2007
STEP 1
Click “Office” button > “Word Options”
STEP 2
Now click “Popular” option and under “Personalize your copy of Microsoft Office” section, type the new author name in-front of “User name” field and type “Initials” according to your choice and click “OK” to make the change affective
By changing the author name in Word this will effect on the whole Microsoft Office applications likeExcel, PowerPoint and others…
Monday, October 15, 2012
How to Open Excel 2010 in Separate Windows
Here is what you do to open two seperate Windows in Excel:
To solve the problem you need to start two separate instances of Excel.
To do this:
Run Excel through the Start menu and open one instance -> Then click it again to open a second window. You can now use these two instances to open the files that you want to see.
If you double click the files when opening them, they will usually all open in the one instance of Excel!
To solve the problem you need to start two separate instances of Excel.
To do this:
Run Excel through the Start menu and open one instance -> Then click it again to open a second window. You can now use these two instances to open the files that you want to see.
If you double click the files when opening them, they will usually all open in the one instance of Excel!
Sunday, October 14, 2012
What Dogs Can Eat?
Food Offers - Dogs - http://www.foodoffers.net/dog/What-Dogs-Can-Eat.html
You can ensure your dog has a healthy, well-balanced diet by asking your vet to recommend a quality dog food. A well-designed dog food gives your pet all the nutrients it needs for an active and healthy life. But that doesn't mean you can't sometimes give your dog human food as a special treat -- as long as portions are limited, and the foods are cooked, pure, and not fatty or heavily seasoned.
Food Offers - Dogs - http://www.foodoffers.net/dog/What-Dogs-Can-Eat.html
You can ensure your dog has a healthy, well-balanced diet by asking your vet to recommend a quality dog food. A well-designed dog food gives your pet all the nutrients it needs for an active and healthy life. But that doesn't mean you can't sometimes give your dog human food as a special treat -- as long as portions are limited, and the foods are cooked, pure, and not fatty or heavily seasoned.
LEAN MEATS
Most dogs are fine eating lean cuts of meat that have been thoroughly cooked. Be sure to remove all visible fat -- including the skin on poultry. Also be sure that there are no bones in the meat before you give it to your dog.SOME FRESH FRUITS
Slices of apples, oranges, bananas, and watermelon make tasty treats for your dog. Be sure to remove any seeds first, though. Seeds, stems, and leaves can cause serious problems.SOME VEGETABLES
Your dog can have a healthy snack of carrot sticks, green beans, cucumber slices, or zucchini slices. Even a plain baked potato is OK. Be sure, though, not to let your dog eat any raw potatoes or any potato plants it might have access to in your garden.COOKED WHITE RICE AND PASTA
Dogs may enjoy plain white rice or pasta after it's cooked. And, a serving of plain white rice with some boiled chicken can sometimes provide welcome relief from gastrointestinal upset.Food Offers - Dogs - http://www.foodoffers.net/dog/What-Dogs-Can-Eat.html
Messenger Error Code 800488eb
If you encounter this problem with Microsoft Live Mail or Messenger you need to do the following to solve the problem:
1. Go to Control Panel -> Then Add/Uninstall programs
– Here you will see a list of all your programs that you can change or uninstall -> Select Windows Live Messenger/Essentials,
you will then have the option to uninstall or reapir -> select repair,
wait for it to load and it will fix itself, and the problem will be solved.
This solution will work on Windows Vista, 7 and 8.
1. Go to Control Panel -> Then Add/Uninstall programs
– Here you will see a list of all your programs that you can change or uninstall -> Select Windows Live Messenger/Essentials,
you will then have the option to uninstall or reapir -> select repair,
wait for it to load and it will fix itself, and the problem will be solved.
This solution will work on Windows Vista, 7 and 8.
How to Hide Your Birthday on Windows Live Hotmail and Messenger
If you want to hide your birth of date and keep it private from friends or public, you can follow these easy steps:
First start by logging into your Hotmail account :D
Then follow these steps or look at the screenshot below:
1. Click “Profile” in the top right corner -> Then click “detail” in the right side menu, below Profile.
2. Here you will see the following option: Shared with: Some friends (except limited access).
You can then change your privacy to “Me” forexample.
First start by logging into your Hotmail account :D
Then follow these steps or look at the screenshot below:
1. Click “Profile” in the top right corner -> Then click “detail” in the right side menu, below Profile.
2. Here you will see the following option: Shared with: Some friends (except limited access).
You can then change your privacy to “Me” forexample.
Subscribe to:
Posts (Atom)