Help with If function

[mrosso2013]

So in general we are trying to calculate commission. I make 2% on anything thats is 15000 and less. Once I hit 15001 I make 5% on that.

I cannot figure out the correct formula for the following. trying to figure out commission

B3 = 16000

I need a formula thats tells me if B3 is less than or equal to 15000 I want it to calculate 2% of B3, with the max being 15000 which it can be calculated off of.

If it is greater than 15,000 than i need whatever is over the 15000 gets a 5% commission.

So in general we are trying to calculate commission. I make 2% on anything thats is 15000 and less. Once I hit 15001 I make 5% on that.

 

[gaz_chops]

Try

=MIN(B3,15000)*2%+MAX(0,B3-15000)*5%

 

[Arjan77]

Or try:
=IF(B3<=15000,B3*0.02,300+(B3-15000)*0.05)

 

[pjmorris]

Hi and welcome to the forum.

If the figure on which commission is to be calculated is in B3 then in whichever cell you want the commission enter: =min(15000,B3)*2%+max(0,B3-15000)*5%

note that if B3 is empty the formula will return 300, to avoid this use: =if(B3<>"",min(15000,B3)*2%+max(0,B3-15000)*5%,"")

Hope this helps.