SOLVED

Excel Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1219168%22%20slang%3D%22en-US%22%3EExcel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1219168%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELet%2C%20Cell%20E51%20is%2010%25.%3C%2FP%3E%3CP%3EI%20need%20a%20formula%20in%20Cell%20E52.%3C%2FP%3E%3CP%3EConditions%20are%20mentioned%20below%3A%3CBR%20%2F%3E*%20If%20E51%20is%20between%207%25%20and%2010.50%25%2C%20E52%20will%20be%20the%20value%20of%20E51%20i.e.%20between%207%25%20and%2010.50%25%2C%3C%2FP%3E%3CP%3E*If%20E51%20is%207%25%20or%20less%20than%207%25%2C%20E52%20will%20be%207%25%2C%3CBR%20%2F%3E*If%20E51%20is%2010.5%25%20or%20greater%20than%2010.5%25%2C%20E52%20will%20be%2010.5%25%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1219168%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1219223%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1219223%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F578075%22%20target%3D%22_blank%22%3E%40Oliullah%3C%2FA%3E%26nbsp%3BThis%20one%20in%20E52%20should%20do%20it.%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DIFS(E51%26gt%3B10.5%25%2C10.5%25%2CE51%26gt%3B7%25%2CE51%2CE51%26lt%3B%3D7%25%2C7%25)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1961846%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1961846%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3BThanks%20a%20lot.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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 Replies
best response confirmed by Oliullah (Occasional Contributor)
Solution

@Oliullah This one in E52 should do it.

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

 

@Riny_van_Eekelen Thanks a lot.