I would recommend looking at this problem along the lines of a step by step node solution rather than a replacement for an excel formula. Take a look at the below post and see if you can tailor it for your conditional requirements.
1 Like