trying to get Excel to calculate if

%3CLINGO-SUB%20id%3D%22lingo-sub-2916791%22%20slang%3D%22en-US%22%3Etrying%20to%20get%20Excel%20to%20calculate%20if%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2916791%22%20slang%3D%22en-US%22%3E%3CP%3ETrying%20to%20set%20a%20if%20function%20for%20commission.%20we%20have%20it%20set%20to%20where%20if%20under%20800%24%20to%20return%20200%20commission.%20and%20if%20above%20800%20to%20take%20it%20and%20multiply%20by%20.25.%20how%20would%20i%20write%20this%20rule%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2916791%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2916918%22%20slang%3D%22en-US%22%3ERe%3A%20trying%20to%20get%20Excel%20to%20calculate%20if%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2916918%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1204043%22%20target%3D%22_blank%22%3E%40Lssrob%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20is%20a%20gap%20in%20your%20rules.%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3D(A1%26lt%3B800)*200%2B(A1%26gt%3B800)*A1*0.25%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2917216%22%20slang%3D%22en-US%22%3ERe%3A%20trying%20to%20get%20Excel%20to%20calculate%20if%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2917216%22%20slang%3D%22en-US%22%3Eoh%20one%20more%20thing%20if%20its%20zero%20i%20want%20zero%20to%20stay%3C%2FLINGO-BODY%3E
New 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)