Forum Discussion
jconrad1211
Feb 03, 2022Copper Contributor
Trouble with <>= in formula
I have been trying to put together a formula to calculate commissions that are on a tier that increases based on adding previous months gross margin to current months gross margin. We have 5 differe...
jconrad1211
Feb 04, 2022Copper Contributor
Thanks Everyone! I finally figured out what I was doing wrong. The highest number needed to be at the front of the formula because once one of the criteria was met, it stopped looking at the rest of the formula. Thank you everyone for your time and input.