Hi all

I 'm really struggling here and would appreciate any help!

I'm trying to get an IF statement that will calculate commision.

If a margin on a particular sale is 35% or below, then commision is 0%. If margin is between 36 and 37 %, then commision is 1%, etc...

Is this doable?? It's been driving me mad all day today.

Many thanks

I 'm really struggling here and would appreciate any help!

I'm trying to get an IF statement that will calculate commision.

If a margin on a particular sale is 35% or below, then commision is 0%. If margin is between 36 and 37 %, then commision is 1%, etc...

Is this doable?? It's been driving me mad all day today.

Many thanks

## Comment