trying to get Excel to calculate if

Copper Contributor

Trying to set a if function for commission. we have it set to where if under 800$ to return 200 commission. and if above 800 to take it and multiply by .25. how would i write this rule  

4 Replies

@Lssrob 

There is a gap in your rules.

=(A1<800)*200+(A1>800)*A1*0.25
oh one more thing if its zero i want zero to stay
and if its blank or 0 to = represent 0$

@Lssrob 

Slice by slice.

=CHOOSE(MATCH(A1,{0;0.01;800.01},1),0,200,A1*0.25)