Powerquery IF contains text, then make value -ve

[jayjay123]

Hi!
I have 2 columns.
Column A - Amount ($) all in absolute values
Column B - Status (either named as Accepted / Cancelled)

In excel, we could input a formula =IF(B1="Cancelled",-A1,A1)
Can this be done in Powerquery? If so, how would I do this?

Thanks!

 

[shaowu459]

= Table.AddColumn(Source,"New Amount",each [Amount]*(if [Status]="Cancelled" then -1 else 1))

 

[jayjay123]

thank you!