scalc: =MAX(SUM(F12:I12),1)

users
#1

Hi

I want to have a column in which each value is either the sum of previous columns or if the sum exceed the value of 1, it is subsituted by 1.

So I tried =MAX(SUM(F12:I12),1)

But it does not work. What do I miss?

Thanks

Uwe Brauer

#2

Hi

I want to have a column in which each value is either the sum of
previous columns or if the sum exceed the value of 1, it is
subsituted by 1.

So I tried =MAX(SUM(F12:I12),1)

But it does not work. What do I miss?

=MIN(SUM(F12:I12),1) ?

#3

Just that you need =MIN(SUM(F12:I12),1) instead?

I trust this helps.

Brian Barker

#4

Yes, of course, thanks, I don't know where my head was when I wrote
this, sorry for the noise and thanks for your help.

#5

Yes, of course, thanks, I don't know where my head was when I wrote
this, sorry for the noise and thanks for your help.