I have multiple conditions to check but this is the basic format I am trying
to create.
If field one has a certain value and field two has a certain value then fill
field. if those conditions are not met another set of values can be tested
for.. and so on if no conditions are met then the fiield should be blank.