Como usar fórmulas no Microsoft Outlook 2010?

0

Eu preciso usar uma fórmula no Microsoft Outlook 2010 que usamos no Excel. Existe alguma maneira eu posso usar qualquer fórmula no Outlook?

    
por user3475 25.10.2013 / 16:51

1 resposta

0

No oficial site de suporte da microsoft , há um tutorial sobre como usar fórmulas. Claro que você tem que editá-lo e usar suas fórmulas, mas, basicamente, explica bem:

This formula calculates the price of buying a certain quantity of items at a particular price:

  1. Open a new standard Message form.
  2. On the Tools menu, point to Forms, and then click Design this Form.
  3. Click the (P.2) tab to open a new blank design page. Initially, this page is not displayed when running. After you add controls, this page is displayed automatically.
  4. In the Field Chooser, click New to create three new fields of type Number and format 2 Decimal. (These fields are referred to as field1, field2, and field3 throughout the rest of this article.) Add them to your form by dragging them to the blank P.2 page.
  5. Right-click the text box of field1, and then click Properties. Click the Value tab, click to select the Set the initial value of this field to check box, and then type 3.50 in the text box. Click Calculate this formula when I compose a new form.
  6. Right-click the text box of field3, and then click Properties. Click the Value tab, click to select the Set the initial value of this field to check box, and then click Calculate this formula automatically. Click Edit, and then add the following formula in the text box.

    NOTE: Do not copy the following code as-is. Change field1 and field2 to the actual names of the fields that you created in step 4 and added to your form:

    [field1] * [field2]
    
  7. On the Form menu, click Run this Form. Add a number in field2. When you use the TAB key to move out of the text box, field3 automatically changes based on the values in field1 and field2.

Origem

    
por 25.10.2013 / 17:00