Many a times writing nested IF() statements become cumbersome, lengthy and highly prone to errors. In worksheet named “Question”, one would like to avoid using spare columns for computation of landed value for the three product sources (“CKD”, “LMP”, “IMP”). While one can use a nested IF() statement, it would be unmanageable because of the length of the […]
Read More →
Conditional testing without lengthy nested IF functions
{ 0 Comments }