I am a newbie and have come across a formula like this:
=IF(AL:AL>0,"Returned",IF(AK:AK>0,"Released",IF(AJ:AJ>0,"Complete",IF(AB:AB>0,"In Process",IF(B:B>0,"In House",IF(#REF!>0,"Dist. Centre",IF(A:A>0,"Incoming","")))))))
Can all the gurus out there please explain to me in layman term what is forumla mean at all?
e.g. what is AL:AL > 0 means? I think it means entire row "AL" but why it is comparing to "> 0", is that means counting # of records in column "AL"? and there is a part with "#REF!" that puzzles me too...
Thanks for helping!
=IF(AL:AL>0,"Returned",IF(AK:AK>0,"Released",IF(AJ:AJ>0,"Complete",IF(AB:AB>0,"In Process",IF(B:B>0,"In House",IF(#REF!>0,"Dist. Centre",IF(A:A>0,"Incoming","")))))))
Can all the gurus out there please explain to me in layman term what is forumla mean at all?
e.g. what is AL:AL > 0 means? I think it means entire row "AL" but why it is comparing to "> 0", is that means counting # of records in column "AL"? and there is a part with "#REF!" that puzzles me too...
Thanks for helping!