Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-3124042%22%20slang%3D%22en-US%22%3EExcel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3124042%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20wanting%20to%20be%20able%20to%20add%20conditions%20to%20my%20formulas.%20Im%20trying%20to%20write%20the%20formula%20to%20be%20able%20for%20if%20the%20cell%20is%20greater%20then%2086%20then%20it%20change%20to%2086%20in%20the%20formula%20but%20not%20in%20the%20cell%20itself.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3124042%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I am wanting to be able to add conditions to my formulas. Im trying to write the formula to be able for if the cell is greater then 86 then it change to 86 in the formula but not in the cell itself. 

2 Replies

@Golions21 

With your permission, if I may recommend, provide more information.

You'll get a quicker and more accurate answer, and those who want to help don't have to invest time guessing the problem.

What I recommend: Always inform about your Excel version, operating system, storage medium/hard drive, OneDrive, Sharepoint, etc.).

If possible, add a file (without sensitive data) and use this file to describe your project step by step, or add photos with the appropriate description.

Don't forget that not every Excel user has a clue about every job and that what you see he can't see.

In this link you will find some more information about it:

Welcome to your Excel discussion space!

 

Thank you for your understanding and patience

 

NikolinoDE

I know I don't know anything (Socrates)

@Golions21 Let's say "the cell" you want to include in a formula is in A1 and its value should not exceed 86, the relevant portion of such formula would look like this:

MAX( 86, A1)

 

So, as an example, you could build a formula like:

 

=25% * MAX(86,A1)

 

which will calculate 25% of the value in A1 where that value is maximised at 86.