If then formulas

[EMCarr]

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

[#2]

@EMCarr 

Do you mean

=MIN(..., 10)

[#3]

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.

[#4 · Accepted solution]

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)

[#5]

It worked! that's great. thanks!