Exponenciel - Efficient and affordable Sage ACT! add-ons

You are here: home > support > online help > automatic field calculations for act! 2020 > table of content

Online help
Automatic Field Calculations

PREVIOUS TOPIC
Creating a calculation

NEXT TOPIC
Yes/No Fields

Testing values

Automatic Field Calculations allows you to test values. This important task is carried out by the If function. It is similar to the If function in Excel. Here is its syntax: value_if_true is the placeholder for the value that will be written to the target field if the logical test is passed, value_if_false if it is not passed.

In the example shown below, we are testing the value of FieldA. If it is California, then we write Local to the target field, else we write Interstate.

When testing for an empty field, use ="" (equals empty) or <>"" (different than empty) as shown here:

If you want nothing to happen if the condition is false, just skip the last argument:

If you want nothing to happen if the condition is true, just skip the middle argument:

PREVIOUS TOPIC
Creating a calculation

NEXT TOPIC
Yes/No Fields

Back to the Table of Content

   

Across this Web site, ACT! and ACT! Premium, Sage ACT! Pro and Sage ACT! Premium are referred to as ACT! or Sage ACT!.

home | products | support | order now | resellers | contact us | meet now
Design by Exponenciel

Exponenciel has been a leading developer of Sage ACT! add-ons, Sage ACT! addons, Sage ACT! plug-ins, Sage ACT! plugins since 2001.
ACT!, ACT! for Workgroup, ACT! for Web, Sage ACT! Pro and Sage ACT! Premium are registered trademarks of Sage Corporation.