I want to restrict the value of a cell

English
#1

Hi, a cell’s value is calculated using a formula, I want to restrict the value of this cell. It must be 20 or less, if it is over 20, I want it to default to 20. Any way I can do that with LibreOffice Calc?

#2

Hallo

=MIN( 20 ; your_formula )
3 Likes
#3

Thank you very much

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.