IFs formula request

[Muthukrishnan V]

Excel 365

Cell B5 contains 32500 in numerical format.

Based on Cell B5, I require a formula in Cell C5 to give

output (50% upto 26000; 40% from 26001; Minimum 13500)

Kindly advise me formula.

 

[Armstrong_N14]

Sorry, the requested output is confusing. can you explain further, please?

 

[Muthukrishnan V]

Sir, 50% upto 26000; 13000 plus 40% from and above 26001
; Minimum 13500.

 

[Ezguy4u]

Ok we have to start somewhere. Now I am assuming a lot of things here and I am usually wrong about a lot of things. And I usually miss something but here we go. Now I just want to get the input and output straight. So I am going to say you want to multiply cell B5 by 50% up to 26,000. That gives you the 13,000. Then you want to multiply cell B5 by 40% for numbers 26,001 and higher but you want a minimum of 13,500. But as you can see 33,750 times 40% give you 13,500 but 33,750 is bigger than 32,500 you say is in B5. Or how about this, we put 13,500 from 26,001 to 33,750 then multiply 33,751 times 40%. Now if I am missing something in your request let us know. So let the discussion begin.

Book.xlsx
	B	C
1	1
2	26,000	13,000
3	26,001	10,400
4	33,750	13,500
Sheet1

Cell Formulas
Range	Formula
C2	C2	=B2*0.5
C3:C4	C3	=B3*0.4

 

[Scott Huish]

Is this what you want?

Book1
	B	C
5	32500	15600
Sheet1

Cell Formulas
Range	Formula
C5	C5	=(MIN(MAX(B5,13500),26000)*0.5)+(MAX(0,B5-26000)*0.4)

 

[Ezguy4u]

Well Mut... hasn't answered anything for some time now but I was thinking about this problem and as a guess I am going to say the below might be close.

WorkBook 1.xlsx
	B	C
5	26,001	13,500
Sheet1

Cell Formulas
Range	Formula
C5	C5	=IF(B5>=33750,B5*0.4,IF(B5>=26001,13500,B5*0.5))