Hi!
I’m having trouble finding out how to fix this long if conditional clause in a formula column I have on a board.
The goal is to first check if the deal is a Rental. If it is, then the splits are calculated having the total comission generated from the entire deal in mind. If not, the splits are calculated having only the comission generated from the first contract in mind.
Here is the code:
IF ({Type of deal} = “Rental”, IF({Agent} = “Simone”, {Total Comission} * 0.4, IF({Agent} = “Hugo”, {Total Comission} * 0.5, IF({Agent} = “Guilherme”, {Total Comission} * 0.4, IF({Agent} = “Stephanie 0.5”, {Total Comission} * 0.25, IF({Agent} = “Pedro”, {Total Comission} * 0.4, IF({Agent} = “Stephanie 0.25”, {Total Comission} * 0.125, 0)))))) , IF({Agent} = “Simone”, {Comission on first contract} * 0.4, IF({Agent} = “Hugo”, {Comission on first contract} * 0.5, IF({Agent} = “Guilherme”, {Comission on first contract} * 0.4, IF({Agent} = “Stephanie 0.5”, {Comission on first contract} * 0.25, IF({Agent} = “Pedro”, {Comission on first contract} * 0.4, IF({Agent} = “Stephanie 0.25”, {Comission on first contract} * 0.125, 0)))))))
Some screenshots:
Thanks in advance for the help!