Question

Need help on the formula for this pls Each month if a salesperson equals or exceeds a 12% commission target, they receive an additional bonus of $1,250 and Insert a column for each month to determine if the salesperson will receive the bonus and This can be achieved by combining an If and a Vlookup statement

Need help on the formula

Sheet 1

Breeze Appliance
Date:	12/05/2019
Branch
Commission Target	12%
Additional Bonus	$1,250.00
Salesperson	Jan	Jan Bonus	Feb	Feb Bonus	Mar	Mar Bonus
Gibbons, Barry	$2,450.00		$3,680.00		$3,360.00
Pascoe, Ien	$8,890.00		$9,770.00		$7,988.00
Walters, Denise	$4,765.00		$6,750.00		$7,420.00
Stringer, Lee	$7,680.00		$6,995.00		$5,600.00
Knott, Delia	$5,790.00		$4,987.00		$4,325.00
Thompson, James	$4,730.00		$5,450.00		$6,740.00
Ritchie, Ross	$7,988.00		$8,664.00		$6,950.00
Gordon, Marie	$6,750.00		$7,889.00		$8,745.00
Totals	$49,043.00	$0.00	$54,185.00	$0.00	$51,128.00	$0.00
Summary Sales AV	$6,100.00		$6,800.00		$6,400.00
Summary Sales MAX	$8,900.00		$9,800.00		$8,700.00
Summary Sales MIN	$2,500.00		$3,700.00		$3,400.00

Sheet 2

Amount	% Comm
0	0.00%
2,650	1.50%
3,300	3.00%
3,950	4.50%
4,600	6.00%
5,250	7.50%
5,900	9.00%
6,550	10.50%
7,200	12.00%
7,850	13.50%
8,500	15.00%
9,150	16.50%
9,800	18.00%

Answer 1

Enter this formula in bonus column with replacing 2450 by cell reference

=IF(Vlookup(2450,Sheet 2!$A$2:$B$14,2,TRUE)>=$B$6,$B$7,0)

Lets say the data in Sheet 2 starts from A1 i.e, heading is in A1 and numbers are from row 2 onwards

Lets say 12% is contained in Sheet 1 Cell B6
Lets say 1250 is contained in Sheet 1 Cell B7