Simplify if-statement

[eirikdaude]

I have a spreadsheet in which the user enters the answer to several yes / no questions and based on these answers I want to decide whether a certain row contains a "Vesentlig anvendelse".

The flow to decide whether it does follows this chart, where "ja" = "yes" and "nei" = "no":

The table in my spreadsheet looks like this,

where columns I to L contains the answers to the questions, and column M contains the answer to whether it's a "Vesentlig anvendelse".

The formula I've come up with is

=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")))

but I feel it is rather big and clunky. Do you guys see any way to simplify this?

 

[jasonb75]

It probably just looks big due to the length of the table names, there are only 5 IF's in the formula which is quite reasonable for what you're doing.
Trying to reduce the number of functions in this instance would quite possibly cause errors in the results.