Using an If statement to show different data

[analystdude96]

I have a dataset that looks like this

Name Status  Result

Jeff       Yes           1

Mark    No             0

Tim       Yes           1

Sarah  No             0

In the field expression editor of both the Result and Status columns, I have used the following to only display those rows with both a 'Yes' in the Status column and a 1 in the 'Result' column, using these lines of code:

=if(Result =1,  Result )

  =if(Status ='Yes', Status)

So my app now displays :

Name Status  Result

Jeff       Yes           1

Tim       Yes           1

My problem is that I now want the Result column to show 'Accepted' instead of the number 1, as that doesn't make much sense as just an integer so I need text here instead.

Any help would be appreciated greatly.

Thank you

[m_woolf · Accepted solution]

=if(Result =1,  'Accepted')