On Wed, 04 Jul 2018 18:22:35 +0200 Uwe Brauer <firstname.lastname@example.org> 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?
Thanks Uwe Brauer