Hjælp til IF kode
Er der en lettere måde at skrive dette på:=IF(C1="";M1;
IF(D1="";M1&" "&C1;
IF(E1="";M1&" "&C1&" "&D1;
IF(F1="";M1&" "&C1&" "&D1&" "&E1;
IF(G1="";M1&" "&C1&" "&D1&" "&E1&" "&F1;
IF(H1="";M1&" "&C1&" "&D1&" "&E1&" "&F1&" "&G1;
IF(I1="";M1&" "&C1&" "&D1&" "&E1&" "&F1&" "&G1&" "&H1;
IF(J1="";M1&" "&C1&" "&D1&" "&E1&" "&F1&" "&G1&" "&H1&" "&I1;
IF(K1="";M1&" "&C1&" "&D1&" "&E1&" "&F1&" "&G1&" "&H1&" "&I1&" "&J1;
IF(L1="";M1&" "&C1&" "&D1&" "&E1&" "&F1&" "&G1&" "&H1&" "&I1&" "&J1&" "&K1;M1&" "&C1&" "&D1&" "&E1&" "&F1&" "&G1&" "&H1&" "&I1&" "&J1&" "&K1&" "&L1))))))))))