AnsweredAssumed Answered

case statement using IsEmpty, question

Question asked by kilbot on Mar 21, 2011
Latest reply on Mar 21, 2011 by philmodjunk

Title

case statement using IsEmpty, question

Post

I have 2 fields and I want to write a case statement to the following effects:

I both fields are empty to do nothing,

if both contain text give error message

and if one is empty and the other has text get the one that has text.

So I thought I would need to write a case statement for this but got lost when I had to think if 1 had text. Is there a way to make a Not IsEmpty calculation:

Case(IsEmpty(field1) and IsEmpty(field2);"";

Then I got stuck

Thanks

Outcomes