Returning value if number falls between options and using in sumif formula

[masterexcelbundle]

Hi,
I have a tiered reward system where if my employees falls between a 4 tiered system they are paid a bonus. I am trying to work out a formula to work this out automatically.

So on 1 page I have the tiered system as

Under 98.4% = $0
98.5% - 98.99% = $50
99% - 99.99% = $150
100% = $300

They are also paid on what full time equivalent hours they work, barely any are full time, and the above numbers are based on full time employees.

Currently I am having to find the actual amount and I am entering the formula as c3=300*(a3) = as I manually entered in $300 however can I put in a formula that if cell B3 falls between X, it will return X value to then times by cell A3

a1	b1	c1
FTE	Sep Error	Amount
0.3625	100.00%	108.75

Thankyou in advance

 

[etaf]

=IF( B2<0.985, 0 , IF( B2<0.99, 50*A2 , IF( B2<1, 150*A2 , 300*a2 )))

Book6
	A	B	C	D	E
1	FTE	Sep Error	Amount
2	0.3625	100.00%	108.75		108.75
3					0
4					0
Sheet1

Cell Formulas
Range	Formula
E2:E4	E2	=IF( B2<0.985, 0, IF( B2<0.99, 50*A2, IF( B2<1, 150*A2, 300*A2 )))

 

[Peter_SSs]

Another option that you could test

=LOOKUP(B2,{0,0.985,0.99,1},{0,50,150,300})*A2

 

[masterexcelbundle]

thankyou they both worked, cheers!

 

[Peter_SSs]

You're welcome. Glad we could help. Thanks for the follow-up.

 

[etaf]

you are welcome