if statement in SQL computed Column Specification
<p>I'm trying to built in if statement in computed column
What I'm trying to accomplish should look like this but this is more pseudo code:
SalePrice-Cost-(if(isConsigned=1 Then Payout else 0))</p>

<p>How do I this and can I use if statement inside computed column or it should be something else?</p>