New Contributor

# trying to get Excel to calculate if

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

# Re: trying to get Excel to calculate if

There is a gap in your rules.

=(A1<800)*200+(A1>800)*A1*0.25

# Re: trying to get Excel to calculate if

oh one more thing if its zero i want zero to stay

# Re: trying to get Excel to calculate if

and if its blank or 0 to = represent 0\$

# Re: trying to get Excel to calculate if

Slice by slice.

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