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.
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:
Aucun commentaire:
Enregistrer un commentaire