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

classic Classic list List threaded Threaded
5 messages Options
Uwe Brauer Uwe Brauer
Reply | Threaded
Open this post in threaded view
|

scalc: =MAX(SUM(F12:I12),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


--
To unsubscribe e-mail to: [hidden email]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Dave Howorth Dave Howorth
Reply | Threaded
Open this post in threaded view
|

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

On Wed, 04 Jul 2018 18:22:35 +0200
Uwe Brauer <[hidden email]> wrote:

> 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) ?

> Thanks
>
> Uwe Brauer
>
>


--
To unsubscribe e-mail to: [hidden email]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Brian Barker Brian Barker
Reply | Threaded
Open this post in threaded view
|

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

In reply to this post by Uwe Brauer
At 18:22 04/07/2018 +0200, Uwe Brauer wrote:
>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 substituted by 1.
>
>So I tried =MAX(SUM(F12:I12),1)
>
>But it does not work. What do I miss?

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

I trust this helps.

Brian Barker


--
To unsubscribe e-mail to: [hidden email]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Uwe Brauer Uwe Brauer
Reply | Threaded
Open this post in threaded view
|

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

In reply to this post by Dave Howorth

   > On Wed, 04 Jul 2018 18:22:35 +0200
   > Uwe Brauer <[hidden email]> wrote:


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

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.



--
To unsubscribe e-mail to: [hidden email]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Uwe Brauer Uwe Brauer
Reply | Threaded
Open this post in threaded view
|

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

In reply to this post by Uwe Brauer

   > At 18:22 04/07/2018 +0200, Uwe Brauer wrote:

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

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.

--
To unsubscribe e-mail to: [hidden email]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy