8. IF Fields

IF Fields will allow you to automatically identify the descriptive classification of any given standard score (e.g. label it as Average, Low Average, Very Low, Extremely Low, etc.).

Refer to pages 11 and 12 of the Tutorial PDF for additional information.

IF Fields selectively display conditional statements when a mathematical expression about the data in a bookmarked field is true or not. Basic IF Fields are limited to 2 elements (one is displayed if the expression is true, another is displayed if its not true).  To be able to select from more than two conditional statements you must use "nested" IF Fields (i.e. IF Fields inside other IF Fields).

This video explains the basics of IF Fields and nested IF Fields.

   

Although this may seem complicated, a complete understanding of the syntax and logic of this type of field is not necessary. You only need to know how to modify the copy & paste versions of nested IF Fields that are available in the Sample Codes Document download.

To use these codes:

1. Copy and paste the code in your descriptive paragraph
2. Reveal all codes by pressing Alt+F9
3. Replace all the "STANDARDSCORE" elements with the bookmark of the field whose value is to be described.
4. (Optional) adjust the descriptive classifications to your preferred system

Note: Nested IF Fields can be challenging to create because their syntax must be accurate. Each set of brackets must be inserted using Ctrl+F9 and bracket pairs must remain intact as they are coded. Be cautious when modifying them to maintain the brackets and spaces between each element.

This video explains how to modify the supplied IF Fields (downloaded in the Sample Codes Document) and how the KABC descriptive categories (e.g. 85-115 is Average) are coded.