Forum Discussion
How to combine two complicated IF function together?
So here are the two IF functions I wish to combine together,
IF Formula 1 (Working) =IF($D$20="Left Hands",SMALL(($F$2:$G$2,$F$3:$G$3,$F$4:$G$4,$F$5:$G$5,$F$32:$G$32,$F$33:$G$33,$F$20:$G$20,$F$...
Hope,
to produce shorter formulas, which are better to evaluate, it would be better to change the model so that you can handle the data in contiguous arrays.