An overview of the Portfolio Model About Formulas About Functions Quick Fx Guide - detailed info about required functions  

Q- Fx Guide




 

 

Square Root

         To use the SQRT Function:

               Point and Click the cell in which you want the Square Root located
    
          Enter the formula:

1.       Type:           =       
 
The equal sign Indicates to Excel that you are entering a function

2.       Type:           sqrt 
       This is the name of the function term

3.       Type:           (       
      
Open parenthesis Indicates the start of the argument, (the cell or # to find the root of) 

4.       Input:           
The cell containing the number to find the root of by:

                    Clicking the cell desired (example: A1)

        Typing the cell (example: A1), OR

        Typing in the named cell If you have already named the cell 

5.       Type:           )        
Close parenthesis Indicates the end of the SQRT argument.
 


    
          Press        <ENTER>
    
          The function will automatically find the square root