upper limit

%3CLINGO-SUB%20id%3D%22lingo-sub-2637275%22%20slang%3D%22en-US%22%3ERe%3A%20upper%20limit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2637275%22%20slang%3D%22en-US%22%3EI%20trust%20you%20realize%20this%20is%20an%20incomplete%20posting.%20(You%20don't%20even%20close%20the%20parenthetical%20sentence%20at%20the%20end%2C%20suggesting%20that%20there's%20more%20to%20come....)%3CBR%20%2F%3E%3CBR%20%2F%3EIt%20would%20be%20helpful%2C%20too%2C%20if%20you%20could%20post%20a%20copy%20of%20the%20spreadsheet%20in%20which%20you're%20seeking%20to%20write%20this%20formula.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2637189%22%20slang%3D%22en-US%22%3Eupper%20limit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2637189%22%20slang%3D%22en-US%22%3E%3CP%3Ei%20am%20attempting%20to%20write%20a%20formula%20where%20an%20additional%20output%20is%20calculated%20if%20the%20previous%20sum%20is%20less%20than%20a%20certain%20amount%3B%20however%2C%20i%20need%20to%20set%20an%20upper%20max%20on%20the%20total%20output%20(i.e.%20if%20the%20previous%20sum%20is%20200%20but%20my%20upper%20max%20is%20only%20201%3B%20the%20current%20output%20is%20giving%20me%20a%20higher%20overall%20sum%20than%20201)%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2637189%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

i am attempting to write a formula where an additional output is calculated if the previous sum is less than a certain amount; however, i need to set an upper max on the total output (i.e. if the previous sum is 200 but my upper max is only 201; the current output is giving me a higher overall sum than 201) 

 

1 Reply
I trust you realize this is an incomplete posting. (You don't even close the parenthetical sentence at the end, suggesting that there's more to come....)

It would be helpful, too, if you could post a copy of the spreadsheet in which you're seeking to write this formula.