If then formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-2763904%22%20slang%3D%22en-US%22%3EIf%20then%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2763904%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20create%20a%20spreadsheet%20where%20if%20a%20number%20(a%20result%20of%20other%20formulas)%20is%20less%20than%2010%2C%20then%20it%20will%20fill%20with%20the%20exact%20value%20less%20than%2010.%26nbsp%3B%20I%20am%20not%20sure%20which%20formula%20to%20use.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20on%20iMac%20iOS%20Big%20Sur%2011.5%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2763904%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2763919%22%20slang%3D%22en-US%22%3ERe%3A%20If%20then%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2763919%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1159987%22%20target%3D%22_blank%22%3E%40EMCarr%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDo%20you%20mean%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DMIN(...%2C%2010)%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I am trying to create a spreadsheet where if a number (a result of other formulas) is less than 10, then it will fill with the exact value less than 10.  I am not sure which formula to use.

 

I am on iMac iOS Big Sur 11.5

 

thank you

4 Replies

@EMCarr 

 

Do you mean

 

=MIN(..., 10)

I'm not sure. Is that the formula I should be using? If I have less than 10 apples, fill the bucket with 10-x, where x is the number of apples I have to start. It is not a fixed number but the result of how many apples were picked that day.

Oh, sorry, I misinterpreted your question.

Let's say the number (result of formula) is in D2.

In another cell, enter the formula

 

=MAX(10-D2,0)

It worked! that's great. thanks!