24.4.08

if setning

Þetta er án efa lengsta if setningin sem ég hef gert í excel:

=IF(N4="Kamstål B500C";IF(O5=200;(LOOKUP($O$6;$B$8:$B$12;$D$8:$D$12));IF(O5=265
;(LOOKUP($O$6;$B$8:$B$12;$E$8:$E$12));IF(O5=320;(LOOKUP($O$6;
$B$8:$B$12;$F$8:$F$12));IF(O5=400;(LOOKUP($O$6;$B$8:$B$12;
$G$8:$G$12))))));IF(N4="Gjengestang_K4.6";IF(O5=200;(LOOKUP(O6;
$B$13:$B$16;$D$13:$D$16));IF(O5=265;(LOOKUP(O6;$B$13:$B$16;
$E$13:$E$16));IF(O5=320;(LOOKUP(O6;$B$13:$B$16;$F$13:$F$16));
IF(O5=400;(LOOKUP(O6;$B$13:$B$16;$G$13:$G$16))))));IF(N4=
"Gjengestang_K5.6";IF(O5=200;(LOOKUP(O6;B17:B18;D17:D18));
IF(O5=265;(LOOKUP(O6;B17:B18;E17:E18));IF(O5=320;(LOOKUP(O6;
B17:B18;F17:F18));IF(O5=400;(LOOKUP(O6;B17:B18;G17:G18))))));
IF(N4="Gjengestang K8.8";IF(O5=200;(LOOKUP(O6;$B$19:$B$20;
$D$19:$D$20));IF(O5=265;(LOOKUP(O6;$B$19:$B$20;$E$19:$E$20));
IF(O5=320;(LOOKUP(O6;$B$19:$B$20;$F$19:$F$20));IF(O5=400;
(LOOKUP(O6;$B$19:$B$20;$G$19:$G$20))))))))))

Já excel getur verið hressandi

Engin ummæli: