Rapid problem

%3CLINGO-SUB%20id%3D%22lingo-sub-1575307%22%20slang%3D%22en-US%22%3ERapid%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1575307%22%20slang%3D%22en-US%22%3E%3CP%3EHi.%20I%20am%20wondering%20if%20someone%20can%20help%20me%20out%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20question%20is%20this.%20Let's%20say%20I%20want%20to%20make%20cell%20A2%20display%20a%20number%20(35%2C%20for%20example)%2C%20and%20decrement%20that%20value%20if%20a%20numeric%20value%20is%20entered%20in%20A1.%20So%2C%20for%20instance%2C%20if%20A1%20would%20contain%201%2C%2034%20would%20be%20the%20result.%20If%20you%20entered%2010%20in%20A1%2C%20A2%20would%20display%2025%2C%20etc.%20Now%2C%20for%20additional%20detail%2C%20let's%20say%20there's%20a%20value%20the%20cell%20is%20never%20going%20to%20go%20lower%20than.%20For%20example%2C%20if%20I%20wanted%20to%20make%20the%20lowest%20value%20for%20A2%20to%20be%2010%2C%20then%20it%20would%20display%2010%2C%20even%20if%20you%20entered%20100%2C%20or%20even%201%2C000%2C000%20in%20A1.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1575307%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1575324%22%20slang%3D%22en-US%22%3ERe%3A%20Rapid%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1575324%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F753573%22%20target%3D%22_blank%22%3E%40SonAmyFan362%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EEnter%20the%20following%20formula%20in%20A2%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DMAX(35-A1%2C10)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi. I am wondering if someone can help me out?

 

My question is this. Let's say I want to make cell A2 display a number (35, for example), and decrement that value if a numeric value is entered in A1. So, for instance, if A1 would contain 1, 34 would be the result. If you entered 10 in A1, A2 would display 25, etc. Now, for additional detail, let's say there's a value the cell is never going to go lower than. For example, if I wanted to make the lowest value for A2 to be 10, then it would display 10, even if you entered 100, or even 1,000,000 in A1. 

 

 

1 Reply

@SonAmyFan362 

Enter the following formula in A2:

 

=MAX(35-A1,10)