hi,
i have a formula, which one i am using to get result.
this formula is long and taking too much space,

is it possible to make a custom fucntion using vba

the formula is

=IF(I10="LBC",IF(X10>$Y$3,"HB",IF(X10>$Y$5,"LB",IF(X10>$Y$4,"SLB","ESLB"))),IF(I10="JT",IF(X10>$AA$3,"HJT",IF(X10>$AA$5,"LJT",IF(X10>$AA$4,"SLJT","ESLJT"))),IF(I10="J",IF(X10>$AC$3,"HJ",IF(X10>$AC$5,"LJ",IF(X10>$AC$4,"SLJ","ESLJ"))))))

sample.JPG

Thanx