I have a multi-conditional if statement. I have tried it both as a text and number format. I need it to be along the lines of:
if([ibo position]="marketing manager with HOS",[commercial team total],[ibo position]="Marketing manager w/o hos",[Commercial team total],[ibo position]="Platinum Marketing Manager with HOS",[Commercial Team Total],null)
I have also tried it as a case statement. The commercial team total is a number field, I need it to recognize if any of these three conditions are true I need it to return the value in the commercial team total field, otherwise nothing.