How to create the function

Patrick Tan

Hi all, I need your help.

I wanted to create an auto-calculation for the value payable in (Co broke payable) column, when [commission status]@row)=” Co-Broke Fee Payable

However, I also want the calculated value to stay reflected in the (Co broke payable) column, even after I have change [commission status]@row)=” No Pending Issue”..”

Below is what I have tried but fail.

=IF(OR([commission status]@row)=”Co Broke Fee Payable”,[commission status]@row)=”No Pending Issue”,[SIN Commission Received]@row*[Co Broke %]@row,0))

Million thanks in advance

Patrick Tan

@Andrée Starå

a million thanks, it works perfectly.

Andrée Starå

Hi @Patrick Tan

I hope you're well and safe!

Try something like this.

=IF(OR([Commission Status]@row = "Co Broke Fee Payable"; [Commission Status]@row = "No Pending Issue"); [SIN Commission Received]@row * [Co Broke %]@row)

The same version but with the below changes for convenience.

=IF(OR([Commission Status]@row = "Co Broke Fee Payable", [Commission Status]@row = "No Pending Issue"), [SIN Commission Received]@row * [Co Broke %]@row)

Depending on your country/region, you'll need to exchange the comma to a period and the semi-colon to a comma.

Did that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Patrick Tan

@Andrée Starå

a million thanks, it works perfectly.

Andrée Starå

@Patrick Tan

Excellent!

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!