how can i create multiple if statements in a calculated field?
i dont see an else or else if statement in list of commands
i want to do three tests and fill the field contents with 1 of the three possible descriptions
if field 1 > "" then "field one is occupied"
if field 2 > "" then "field two is occupied"
"both field are empty"