if-statement: Excel IF multiple colums

jeudi 27 juillet 2017

Im working with a large excel questionnaire that i would like to simplify the data output for further evaluation.

What im trying to make is an IF statement, so that if the X is in fueloil the P coloum will write Fueloil ect..

=IF(K2="X";K1)

However when im trying to add another IF statement excel returns VALUE. is IF the right way to go about this or is there another way of doing this?

if-statement