Help

Help with a conditional formula

Topic Labels: Formulas
Solved
Jump to Solution
690 2
cancel
Showing results for 
Search instead for 
Did you mean: 
HannahS
6 - Interface Innovator
6 - Interface Innovator

Can anyone tell me where I'm going wrong with this formula?

 

SWITCH( {HS-LA %},
"15%", ({GBP Amount}-{HS-LA Commission}),
"10%", ({GBP Amount}-{HS-LA Commission}-{HS-LA Commission}),
)

Or suggest another way to achieve it - I've tried a few IF options too but can't get that to work either. 

For context, I'm a literary agent and depending on the type of deal I do I either take 15% or 10% commission. Where I take 10% a co-agent will have also taken 10% but that's not necessary for me to track, other than that when I'm working out the author's overall income I need to make sure I know they didn't get it (hence trying to take away my commission twice in those instances here). 

The closest I got to it working (ie, it actually ran something instead of refusing to save because of an error), I got words back instead of numbers and what I need is numbers. 

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

Try removing the trailing comma in your formula:

SWITCH( 
  {HS-LA %},
  "15%", ({GBP Amount}-{HS-LA Commission}),
  "10%", ({GBP Amount}-{HS-LA Commission}-{HS-LA Commission})
)

Screenshot 2024-03-07 at 10.18.18 AM.png

See Solution in Thread

2 Replies 2
TheTimeSavingCo
18 - Pluto
18 - Pluto

Try removing the trailing comma in your formula:

SWITCH( 
  {HS-LA %},
  "15%", ({GBP Amount}-{HS-LA Commission}),
  "10%", ({GBP Amount}-{HS-LA Commission}-{HS-LA Commission})
)

Screenshot 2024-03-07 at 10.18.18 AM.png

HannahS
6 - Interface Innovator
6 - Interface Innovator

Ah! Thank you!