If Statement for multiple criteria on amount

[SH_94]

Hi Community,

I would like to change the positive or negative sign for amount as per screenshot below:

1. If the customer A with the type is Y, change the amount from positive to negative amount. If the customer A with type W, remain the original amount

2. If customer is B remain as per the original amount.

3. If the customer is C, change the amount from positive to negative amount.

May i know how you all will build this workflow ? I had attached the file below for your reference.

[apathetichell]

How about

if [customer name]="C" or ([customer name]="A" and [type]="Y") then -[invoice amount] else [invoice amount] endif

will get you the result you want.

[Qiu]

@SH_94 

In my case, I would prepare a look up table since I believe you have a lot of cretia in your business flow.

The if then formula will then get really messy and a look up table will be easier to maintain.