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...
Feb 03, 2022
Hello
Use this formula
=IF(A1 >=20000,IF(A1>=40000,IF(A1>=60000,IF(A1>=80000,A1*0.1,A1*0.09),A1*0.08),A1*0.07),A1*0.06)
Use this formula
=IF(A1 >=20000,IF(A1>=40000,IF(A1>=60000,IF(A1>=80000,A1*0.1,A1*0.09),A1*0.08),A1*0.07),A1*0.06)