Sep 18 2021 01:12 PM
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
Sep 18 2021 01:32 PM
Sep 18 2021 01:37 PM
SolutionOh, 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)
Sep 18 2021 01:37 PM
SolutionOh, 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)