Excel Formula

[Oliullah]

Hello, 

Let, Cell E51 is 10%.

I need a formula in Cell E52.

Conditions are mentioned below:
* If E51 is between 7% and 10.50%, E52 will be the value of E51 i.e. between 7% and 10.50%,

*If E51 is 7% or less than 7%, E52 will be 7%,
*If E51 is 10.5% or greater than 10.5%, E52 will be 10.5%,

[#2 · Accepted solution]

@Oliullah This one in E52 should do it.

=IFS(E51>10.5%,10.5%,E51>7%,E51,E51<=7%,7%)

[#3]

@Riny_van_Eekelen Thanks a lot.