mardi 1 décembre 2020

Simplify if-statement

I have a table which has several columns containing the answers to yes / no questions, with a final column giving the answer to whether a given row contains a "Vesentleg anvendelse" according to this flow chart.

enter image description here

I created the following if-formula to determine this, but I feel it is a bit clunky - is there any way to simplify it?

=IF([@[Myndighet-, lokal-, sentralkrav?]]="Ja";
    "Ja";
    IF([@[Stort potensial?]]="Ja";
        IF([@[Økonomisk bærekraftig?]]="Ja";
            "Ja";
            "Nei");
        IF([@[Vanskelig å gjennomføre]]="Nei";
            IF([@[Økonomisk bærekraftig?]]="Ja";
                "Ja";
                "Nei");
            "Nei")
        )
    )

The table itself looks like this:

enter image description here

Aucun commentaire:

Enregistrer un commentaire