Thursday, June 30, 2011

How To Create An Argument With Excel

For many of us formula is the F-word in the world of Excel - you either love it or hate it. But formulas are powerful equations that can perform calculations, return information, manipulate the contents of other cells, test conditions, and much, much more. A formula always starts with an equal sign (=). Some useful examples of Excel formulas include: =SQRT(A1) which makes use of the SQRT function to return the square root of the value in A1; =TODAY() this returns the current date; and =IF(A1>0,"Plus","Minus") which tests the cell A1 to determine if it contains a value greater than 0. If the result of the test is true, the text "Plus" appears in the cell; if the result is false, the text "Minus" appears.

The full article appears here:
http://www.microsofttraining.net/article-1776-how-create-argument-with-excel.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com

0 Comments:

Post a Comment

<< Home