OpenOffice-Calc How to set a maximum value for a column

Question

I'm trying to set the maximum number of a column to 50, so any number greater than 50 should show up as 50 in the spreadsheet. I'm not sure if using find and replace is the way to go. I can't seem to find a way to make find and replace look for numbers greater than 50.

Thanks

I'm voting to close this question as off-topic because it's unrelated to programming. — code_dredd, Aug 01 '17 at 01:51

score 0 · Answer 1 · answered Aug 06 '14 at 15:31

0

Never mind found an easy way to do it with an if statement. Ended up using

=IF(B1>50;50;B1)

answered Aug 06 '14 at 15:31

PinkishTitan

21
2

OpenOffice-Calc How to set a maximum value for a column

1 Answers1