G'day NZ Rob,
Best of luck
=IF($B13="X","",IF($R13>0,IF(AND($R13<=Y$8,$R13>X$8),$S13,IF($P13>0,IF(AND($P13<=Y$8,$P13>X$8),$Q13,IF($N13>0,IF(AND($N13<=Y$8,$N13>X$8),$O13,IF($L13>0,IF(AND($L13<=Y$8,$L13>X$8),$M13,IF($I13>0,(IF(AND($I13<=Y$8,$I13>X$8),$E13,(IF(AND($H13<=Y$8,$H13>X$8),$E13,""))))))))))))))
Have I made you happy ??? If yes, please make me happy by pressing theAdd Reputation button in my post.
Please don't forget to do the same to other contributors of this forum.
ThanksI don't void confusion, I create it
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks