Here is the help for the IF https://login.quickbase.com/db/6ewwzuuj?a=dr&r=cm&rl=dvn
In your example since you are testing against just 1 field you can also use the Case function
I had already looked at all of the If statements and didn't find one that would work in my situation. I had used one that works in excel using the If(OR but I kept getting syntax errors. I just used case and this is my formula
Case([Status],"Contracted",Contracted,"Contracted Extend",Contracted,"Location Contracted",Contracted,"Location Contracted Extend",Contracted,[Status])
I am getting a this error.
Formula syntax error
The argument list of the function Contracted must begin with a left parenthesis.