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
On Wed, 04 Jul 2018 18:22:35 +0200
Uwe Brauer 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?
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: