Question
-
Topic
-
EXCEL FORMULA HELP
LockedI need a formula for a tiered commission scale that looks like the below
70=$700, 75=$750, 80=$880, 85=$935, 90=$990, 95=$1045, 100=$1200, 105=$1380, 110=$1580, 115=$1840, 120=$2100, 125=$2188, 130=$2275, 135=$2363, 140=$2450, 145=$2538, 150=$2625, 155=$2713, 160=$2800, 165=$2888, 170=$2975, 175=$3063, 180=$3150.I would enter the numerical number in column B and in the cell directly beside it in column C the commission would be calculated based on the number you enter into column B. I have tried several “IF” formula’s and can’t find one that works and I am desperate at this point please help!!
All Answers
Viewing 1 reply thread