Need help with Drafting a formula.

[Erick44]

In column a I have the percentages, column be is a dollar value. In column c, I want to create a formula to multiple the b column by a percentage based on the percentage value in column a. If an employee hits the percentage mark for a given period then they receive the commission percentage associated the range listed below.

Example

If less than 40% in column a, then multiple value in column b by 15%

If between 40-49.9% in column a, then multiple value in column b by 20%

If between 50-59.9% in column a, then multiple value in column b by 25%

If between 60-69.9% in column a, then multiple value in column b by 30%

 

[mtpaper]

When I do this, I often do intermediary, helper columns, to make it all easier to read. By that I mean:
Column C only deals with the calculation if the value in A is < 40%; @if(a2<=.4,b2*.15,0)
Column D only deals with the calculation if the value in A is between 40% and 49.9%: if(and(a2>=.4,a2<=.499),b2*.2,0)
and so on

One 1 of the 4 columns (Colum C, D, E and F) will have a value > 0

Column G is the sum of Columns c,d,e and f

 

[juddaaaa]

I think this is what you're looking for

=IFERROR(IF(A1<40%,B1*0.15,IF(AND(A1>=40%,A1<=49.9%),B1*0.2,IF(AND(A1>=50%,A1<=59.9%),B1*0.25,IF(AND(A1>=60%,A1<=69.9%),B1*0.3)))),"")

Book1
	A	B	C	D	E
1	35.00%	$10.00	$1.50
2	45.00%	$10.00	$2.00
3	55.00%	$10.00	$2.50
4	65.00%	$10.00	$3.00
5
6
Sheet1

Cell Formulas
Range	Formula
C1:C4	C1	=IFERROR(IF(A1<40%,B1*0.15,IF(AND(A1>=40%,A1<=49.9%),B1*0.2,IF(AND(A1>=50%,A1<=59.9%),B1*0.25,IF(AND(A1>=60%,A1<=69.9%),B1*0.3)))),"")

 

[Erick44]

You are a life saver!!!

 

[Fluff]

Or slightly simpler
=IF(A1<40%,B1*0.15,IF(A1<50%,B1*0.2,IF(A1<60%,B1*0.25,IF(A1<=70%,B1*0.3,""))))