Skip to content

Latest commit

 

History

History
24 lines (20 loc) · 1.05 KB

README.md

File metadata and controls

24 lines (20 loc) · 1.05 KB

Tips

Have you ever found yourself needing to understand how your data is interpreted and classified within a system? Here's a tip to simplify that process.

Ghost

Example

Sample Usage 

If(D4="","",If(D4>=80%,"Approved","Disapproved"))

Syntax 

If(value1,value2,If(value3,value4,value5))
  • value1: the initial value is being compared to an empty value.
  • value2: if the initial value is blank, then the field will remain blank.
  • value3: the value entered in the 'Test' column is compared to 80%.
  • value4: if the value3 is greater than or equal to 80%, then the field will display the word 'Approved'.
  • value5: if the value3 is less than 80%, then the field will display the word 'Disapproved'.

Note

These steps outline a process of evaluating and classifying data points based on predefined criteria, providing a clear understanding of the status or outcome associated with each value within the data processing system.