Forum Discussion
Shorten excel formula for data validation
Hello
I was wondering if someone could help me shorten a formula as my current formula (below) is too long for data validation.
=IF(C10="KABI 8",48,IF(C10="KABI 11",64,IF(C10="KABI 14",80,IF(C10="KABI(P) 5",32,IF(C10="KABI(P) 7",43,IF(C10="KABI(P) 9",53,IF(C10="SF KABI 4",20,IF(C10="SF KABI 8",40,IF(C10="SF KABI 12",60,IF(C10="SF KABI 16",80,IF(C10="SF KABI(P) 9.8",48,IF(C10="SF KABI 8 EF",0,IF(C10="SF KABI 12 EF",0,IF(C10="SF KABI 16 EF",0))))))))))))))
Thank you
Hi,
Better to keep you constants in helper range - shorter the formula and much easier in maintenance. After that like
=IFNA(INDEX($F$1:$F$14,MATCH(C10,$E$1:$E$14,0)),"")
see attached
