Derived column problem

I want to implement all this four condition in one derived column expression.

if (Column1== 1)

{

OutputColumn = ColumnA- Column1RATE
}

if (Column2 == 1)

{

OUtputColumn = ColumnA- Column2RATE
}

if (Column3 == 1)

{

OUtputColumn = ColumnA- Column3RATE
}

if (Column4 == 1)

{

OUtputColumn = ColumnA- Column4RATE
}

please suggest

Something like this might work:

(Column1== 1)?ColumnA- Column1RATE?(Column2 == 1)?OUtputColumn = ColumnA- Column2RATE:(Column3 == 1)?ColumnA- Column3RATE:(Column4 == 1)?ColumnA- Column4RATE:0

Frank

|||

Earlier post had typos...

Corrected:

(Column1== 1)?ColumnA- Column1RATE:(Column2 == 1)?ColumnA- Column2RATE:(Column3 == 1)?ColumnA- Column3RATE:(Column4 == 1)?ColumnA- Column4RATE:0