<!DOCTYPE html
  PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<!--
Copyright (c) 2006 UGS Corp.

All Rights Reserved.

This software and related documentation are proprietary to UGS Corp.
-->
<html>
   <head>
      <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
      <title>Vector-Related Functions</title>
      <script language="javaScript">
        abridged="false";
        displayConditions=new Array();
      </script>
      <link type="text/css" href="../css/main_styles.css" rel="stylesheet">
   </head>
   <body class="bodydocs" onload="top.pageLoader()" bgcolor="#FFFFFF">
      <div class="title_topic4" id="xps10_pagetitle">Vector-Related Functions</div>
      <hr noshade="true">
      <p class="para_topic">Vector functions take ranges of spreadsheet cells as the components of a vector and return either scalar values in the current cell, or vector values as a horizontal row of cells.</p>
      <table border="0">
         <tr>
            <td valign="top" align="left"><img align="left" src="../graphics/note.gif" alt="Note" title="Note"></td>
            <td valign="bottom" align="left" width="100%">
               <div class="para_note">
                  <p class="para_note_body">  A vector, such as vector1, is specified by a range of 3 cells (i.e., B1..B3). In either a horizontal or vertical orientation. A scalar value may be specified by a literal value (0.5) or a cell reference to a formula or value.</p>
               </div>
            </td>
         </tr>
      </table>
      <p class="para_topic">ADDVEC(vector1, vector2)</p>
      <p class="para_topic">Returns the sum of two vectors. vector=vector1+vector2</p>
      <p class="para_topic">AFFINEVEC(scalar,vector1,vector2)</p>
      <p class="para_topic">Returns the affine vector combination. vector=vector1 + (scalar*vector2)</p>
      <p class="para_topic">ANGLEVEC(vector1,vector2,vector3)</p>
      <p class="para_topic">Returns the angle between vector1 and vector2 in the plane defined by the normal vector3. The angle ranges from zero to 2*PI.</p>
      <p class="para_topic">CONVEXVEC(scalar,vector1,vector2)</p>
      <p class="para_topic">Returns the convex vector combination. vector=(scalar*vector2) + ((1-scalar)*vector1)</p>
      <p class="para_topic">CROSSVEC(vector1, vector2 )</p>
      <p class="para_topic">Returns the cross product of two vectors.</p>
      <p class="para_topic">DOTVEC( vector1,vector2 )</p>
      <p class="para_topic">Returns the scalar dot product between two vectors.</p>
      <p class="para_topic">LINEARVEC(scalar1,scalar2,vector1,vector2)</p>
      <p class="para_topic">Returns the linear vector combination. vector=( scalar1*vector1) + (scalar2*vector2)</p>
      <p class="para_topic">NEGVEC( vector1 )</p>
      <p class="para_topic">Returns the inverse (negated) vector.</p>
      <p class="para_topic">SCALEVEC( scalar, vector )</p>
      <p class="para_topic">Multiplies a vector by a scalar.</p>
      <p class="para_topic">SUBVEC( vector1, vector2 )</p>
      <p class="para_topic">Subtracts two vectors.</p>
      <p class="para_topic">UNITVEC( vector1 )</p>
      <p class="para_topic">Returns a unit vector.</p>
      <p class="para_topic">VECMAG( vector1 )</p>
      <p class="para_topic">Returns the length (magnitude) of a vector. </p>
   </body>
</html>